Re: PostgreSQL survey
От | Nicholson, Brad (Toronto, ON, CA) |
---|---|
Тема | Re: PostgreSQL survey |
Дата | |
Msg-id | EC55DC235432104F8255702A8D7344D925703A3E@G9W0741.americas.hpqcorp.net обсуждение исходный текст |
Ответ на | Re: PostgreSQL survey ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
Ответы |
Re: PostgreSQL survey
|
Список | pgsql-advocacy |
> -----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 havea comparison for the workload against 9.1? I'm curious about the factor of improvement. Thanks, Brad.
В списке pgsql-advocacy по дате отправления: