On Tue, Apr 28, 2009 at 10:56 AM, Whit Armstrong
> I have the opportunity to set up a new postgres server for our
> production database. I've read several times in various postgres
> lists about the importance of separating logs from the actual database
> data to avoid disk contention.
> Can someone suggest a typical partitioning scheme for a postgres server?
At work I have 16 SAS disks. They are setup with 12 in a RAID-10, 2
in a RAID-1 and 2 hot spares.
The OS, /var/log, and postgres base go in the RAID-1. I then create a
new data directory on the RAID-10, shut down pgsql, copy the base
directory over to the RAID-10 and replace the base dir in the pg data
directory with a link to the RAID-10's base directory and restart
postgres. So, my pg_xlog and all OS and logging stuff goes on the
RAID-10 and the main store for the db goes on the RAID-10.
In response to
pgsql-performance by date
|Next:||From: Whit Armstrong||Date: 2009-04-28 17:48:40|
|Subject: Re: partition question for new server setup|
|Previous:||From: Whit Armstrong||Date: 2009-04-28 16:56:48|
|Subject: partition question for new server setup|