By Unknown Lamer from Slashdot's design-by-committee department
By Unknown Lamer from Slashdot's rev-your-engines department
The PostgreSQL project announced the release of PostgreSQL 9.2 today.
The headliner: "With the addition of linear scalability to 64 cores, index-only scans and reductions in CPU power consumption, PostgreSQL 9.2 has significantly improved scalability and developer flexibility for the most demanding workloads. ... Up to 350,000 read queries per second (more than 4X faster) ... Index-only scans for data warehousing queries (2–20X faster) ... Up to 14,000 data writes per second (5X faster)"
Additionally, there's now a JSON type
(including the ability to retrieve row results in JSON directly from the database) ala the XML type
(although lacking a broad set of utility functions). Minor, but probably a welcome relief to those who need them, 9.1 adds range restricted types
. For the gory details, see the what's new
page, or the full release notes
.Read Replies (0)
By samzenpus from Slashdot's best-practices department
A cascading hardware outage struck subscription payment provider Recurly last week, and that started a long example in how not to manage critical infrastructure
. From the article: "Last Monday, the payment provider suffered an intermittent hardware failure, which prevented the company from processing either payments or refunds. The company says it serves over 1,000 customers, including Adobe, BrightCove, and Fox News Radio, processing recurring payments for subscriptions.
By Friday, the company still hadn’t completely straightened out the mess, providing updates to customers using payment gateways such as Authorize.net and LinkPoint/First Data."Read Replies (0)