On 11/09/12 12:38, Josh Berkus wrote:
On 9/10/12 5:33 PM, Devrim GÜNDÜZ wrote:
Hi,
On Mon, 2012-09-10 at 07:40 -0700, Josh Berkus wrote:
Links, post 'em here:
(EDB sponsored, it seems)
http://www.pcworld.com/businesscenter/article/262107/postgres_92_invites_largescale_enterprise_deployment.html
Yeah, that one came in through EDB's PR agency. It's good coverage,
regardless.
Slashdot:
http://developers.slashdot.org/story/12/09/10/2220202/postgresql-92-out-with-greatly-improved-scalability
[...]
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.
[...]