From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Derek Hamilton" <derek(at)capweb(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Separate Disks |
Date: | 2003-04-12 04:48:50 |
Message-ID: | 16126.1050122930@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
"Derek Hamilton" <derek(at)capweb(dot)com> writes:
> Any help with improving the disk I/O would be much appreciated!
Conventional wisdom is that putting the WAL log on its own spindle is a
big win (at least for databases that have nontrivial write traffic).
This is pretty easy to do, just symlink the pg_xlog directory to another
filesystem. After that you could look at moving indexes off to their
own disk, but the pain-in-the-neck factor is *way* higher at the moment,
and the return not as good. I doubt that pg_clog is really worth
worrying about.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry | 2003-04-12 06:14:27 | Need two languages in the database: Russian and English |
Previous Message | Jeff Fitzmyers | 2003-04-12 02:22:10 | Re: [ADMIN] PLEASE HELP ME URGENT about choosing only the ones |