Re: Large PostgreSQL servers - Mailing list pgsql-general

From Kjetil Nygård
Subject Re: Large PostgreSQL servers
Date
Msg-id 1332360797.26378.14.camel@kjetil.kny.im
Whole thread Raw
In response to Re: Large PostgreSQL servers  (John R Pierce <pierce@hogranch.com>)
Responses Re: Large PostgreSQL servers
Re: Large PostgreSQL servers
Re: Large PostgreSQL servers
List pgsql-general
On Wed, 2012-03-21 at 13:06 -0700, John R Pierce wrote:
> On 03/21/12 12:31 PM, Kjetil Nygård wrote:
> > We wonder if someone could give some hardware / configuration specs for
> > large PostgreSQL installations.
> > We're interested in:
> >     - Number of CPUs
> >     - Memory on the server
> >     - shared_buffers
> >     - Size of the database on disk
>
> oh, and you left out a couple /very/ important specifications...
>
>      - number and speed of storage IO channels
>      - number and speed (RPM) of disk drives


I understand that IO performance, transactions/s, 24/7 vs office hours,
data-complexity etc is also needed to really say how much beating a
database can handle.

I just hoped for some simple numbers, but other relevant performance
numbers etc would be nice as well :-)



Regards,
Kny



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Large PostgreSQL servers
Next
From: Steve Crawford
Date:
Subject: Re: Large PostgreSQL servers