Re: PostgreSQL survey - Mailing list pgsql-advocacy

From Nikolas Everett
Subject Re: PostgreSQL survey
Date
Msg-id CAPmjWd3zcV50e0ttDjzRE42+5+YTfvx-f==0+wu68W7OrTiOvw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL survey  ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>)
Responses Re: PostgreSQL survey
List pgsql-advocacy
> 1. Anyone using PostgreSQL for enterprise mission critical system ?
I've worked at two companies that run their mission critical applications on PostgreSQL. 

> 2. How big are the servers you are running PostgreSQL, Is there
> anyone using more than 32 cores or 256GB memory ?
Ours are likely about half that size and work wonderfully.

> 3. What OS you are using to run this mission critical system on
> PostgreSQL ? Linux, Unix ?
I've seen both RHEL and Debian.


> 4. Who provides PostgreSQL support ? Do you have any support
> contract with a third party company ? If so, how much is the
> monthly support fee ?
We've got impecable support from the mailing lists.  It is tough to find a DBA that knows PostgreSQL.  In general my experience has been that there are far fewer warts on PostgreSQL than on Oracle.

Nik


On Tue, Dec 13, 2011 at 10:57 AM, Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com> wrote:
> -----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.

Thanks,
Brad.


--
Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy

pgsql-advocacy by date:

Previous
From: "Nicholson, Brad (Toronto, ON, CA)"
Date:
Subject: Re: PostgreSQL survey
Next
From: Ned Lilly
Date:
Subject: Re: PostgreSQL survey