Postgres Pro
Downloads
Home   >   mailing lists

Large PostgreSQL servers - Mailing list pgsql-general

From Kjetil Nygård
Subject Large PostgreSQL servers
Date
Msg-id 1332358268.26378.8.camel@kjetil.kny.im
Whole thread Raw
Responses Re: Large PostgreSQL servers  (Frank Lanitz <frank@frank.uvena.de>)
Re: Large PostgreSQL servers  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Large PostgreSQL servers  (John R Pierce <pierce@hogranch.com>)
Re: Large PostgreSQL servers  (Merlin Moncure <mmoncure@gmail.com>)
Re: Large PostgreSQL servers  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view 
Hi,

We are considering to migrate some of our databases to PostgreSQL.

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



PS: I have read in "PosgreSQL 9.0 High Performance" that one should not
use more than 8GB for shared_buffers. But Robert Haas and comments say
that one can use a lot more.
http://rhaas.blogspot.com/2012/03/tuning-sharedbuffers-and-walbuffers.html



Regards,

Kjetil Nygård

pgsql-general by date:

Previous
From: Cody Cutrer
Date:
Subject: Re: Index on System Table
Next
From: Frank Lanitz
Date:
Subject: Re: Large PostgreSQL servers