Re: PostgreSQL survey

> 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(at)hp(dot)com> wrote:

> > -----Original Message-----
> > From: pgsql-advocacy-owner(at)postgresql(dot)org [mailto:pgsql-advocacy-
> > owner(at)postgresql(dot)org] On Behalf Of Kevin Grittner
> > Sent: Monday, December 12, 2011 3:43 PM
> > To: cesarmk(at)gmail(dot)com; pgsql-advocacy(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-advocacy
>