Re: Question about disk layout for new OLAP db

Hi!

On Mon, Aug 3, 2009 at 6:51 AM, Ewan, Michael<michael(dot)ewan(at)intel(dot)com> wrote:
>
> I am new to PostgreSQL.  I'm setting up a new PostgreSQL server to handle large amounts of performance data collected from our batch processing pools, we're currently handling about 8M rows of new data per day stored into tables with about 6B rows total.  The server I have has eight cores and 32GB memory, with 9TB of fibre channel storage.  I'm using LVM2 for disk allocation and XFS so the volume sizes can grow as needed.  The default installation of PostgreSQL 8.4 uses one disk for both data and logs.  Normally you would allocate multiple data disks and a transaction log disk.  I have not seen anywhere in the documentation or configuration files where you can specify extra data disks or separate log disks.
>

For data volumes, you allocate 'tablespaces', which can be used for
individual indexes and tables.
http://www.postgresql.org/docs/8.4/interactive/manage-ag-tablespaces.html

For the separate log disks, you can just use symlinks. Stop the
database, move the pg_xlog directory to your desired location, and
make a symlink from the data directory to the new location. Verify
your permissions and then start the database back up :)

Do you currently have an IO bottleneck?

-selena

--
http://chesnok.com/daily - me
http://endpoint.com - work