partition question for new server setup

From: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: partition question for new server setup
Date: 2009-04-28 16:56:48
Message-ID: 8ec76080904280956p78ee6646hb7ec0ab17086e159@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-04-28 17:37:13 Re: partition question for new server setup
Previous Message Laurent Laborde 2009-04-28 09:53:03 any interest of changing the page size ?