Separate Disks

From: "Derek Hamilton" <derek(at)capweb(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Separate Disks
Date: 2003-04-12 01:12:37
Message-ID: 000701c30090$9c2b7450$1b01a8c0@jcaves.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,

I recently started using PostgresQL and am quickly falling in love with it.
One of the biggest questions I have however is the ability to separate logs
from databases, etc. onto different disks. The reason I'm interested in
this is the application I'm running performs a lot of inserts with a fairly
large set of data and I'm looking to improve performance by separating the
writes taking place on logs, etc.

Also, I'm using the newest version (7.3.2) and I'm not quite sure of the
layout of the files. Inside the data directory I know the base directory
holds the databases for the cluster. However, what is the difference
between the pg_clog and the pg_xlog?

Any help with improving the disk I/O would be much appreciated!

Thanks,
Derek Hamilton

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Fitzmyers 2003-04-12 02:22:10 Re: [ADMIN] PLEASE HELP ME URGENT about choosing only the ones
Previous Message codeWarrior 2003-04-12 00:20:04 Re: Killing only one postmaster