Filesystem and PG configuration

From: RBN <rbn(dot)ggl(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Filesystem and PG configuration
Date: 2010-06-04 15:25:55
Message-ID: AANLkTimm49eoGIF44cy9FU1-OcXe6ekPNbzlQ6jHl__n@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can someone suggest some appropriate initial configuration parameters and
shared memory settings for the following hardware?

I'm running Debian on a Dell with 4x6 core CPU and 128GB memory and writing
to a coraid with 9 x 32GB SSDs RAID 10 using jfs with 8 drives active and 1
as spare.

I'm considering changing to xfs. I'm not sure what block size to use for
the file system, is 8192 appropriate? The OS page size is 4096.

The database is both write and read intensive, with about 750MB of new data
added per week and old deleted every six months to one year.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Florian Pflug 2010-06-05 00:00:39 Re: PITR Recovery Question
Previous Message Kevin Grittner 2010-06-04 15:02:53 Re: PITR Recovery Question