Large PostgreSQL servers

From: Kjetil Nygård <polpot78(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Large PostgreSQL servers
Date: 2012-03-21 19:31:08
Message-ID: 1332358268.26378.8.camel@kjetil.kny.im
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Lanitz 2012-03-21 19:45:57 Re: Large PostgreSQL servers
Previous Message Cody Cutrer 2012-03-21 18:32:46 Re: Index on System Table