> -----Original Message-----
> From:
pgsql-advocacy-owner@postgresql.org [mailto:
pgsql-advocacy- >
owner@postgresql.org] On Behalf Of Kevin Grittner
> Sent: Monday, December 12, 2011 3:43 PM
> To:
cesarmk@gmail.com;
pgsql-advocacy@postgresql.org > Subject: Re: [pgsql-advocacy] PostgreSQL survey
>
> > 2. How big are the servers you are running PostgreSQL, Is there
> > anyone using more than 32 cores or 256GB memory ?
>
> Our biggest server, which has just gone into production, is 32 cores
> with 256GB RAM. We are able to comfortably support several TB of
> databases running tens of millions of database transactions per day
> on servers with 16 cores and 128GB RAM. In benchmarking the latest
> development code, containing features targeted for next year's
> performance-oriented release, I was seeing over 500,000 tps for a
> read-only transaction load and over 30,000 tps for a mixed load
> including a lot of updates. They are not done adding performance
> features for the next release, though. :-)
Sorry to derail the thread - but 500k tps on read and 30k tps on mixed workload of a single server - wow... Do you have a comparison for the workload against 9.1? I'm curious about the factor of improvement.