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? My initial thought was to create /var/lib/postgresql as a partition on a separate set of disks. However, I can see that the xlog files will be stored here as well: http://www.postgresql.org/docs/8.3/interactive/storage-file-layout.html Should the xlog files be stored on a separate partition to improve performance? Any suggestions would be very helpful. Or if there is a document that lays out some best practices for server setup, that would be great. The database usage will be read heavy (financial data) with batch writes occurring overnight and occassionally during the day. server information: Dell PowerEdge 2970, 8 core Opteron 2384 6 1TB hard drives with a PERC 6i 64GB of ram We will be running Ubuntu 9.04. Thanks in advance, Whit -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
