> Er, no, it's not. In fact, for a 3-disk config, I reccommend:
> Disk 1: OS, swap, system logs
> Disk 2: Data + Indexes
> Disk 3: Transaction Log
What is the accepted way of splitting the data from pg_xlog?
I've been testing some configurations for low budget performance, and I haven't been able to make this help vs. one disk. (under osx, ymmv)
I rsync'd the pg_xlog directory to another disk, then set up a symlink pointing from the data/pg_xlog to /other/disk/pg_xlog.
I then got tps numbers that were 2/3 of the single ide drive speed. The only explanation I can come up with is that something is seeking to the symlink, then doing the actual write on the other drive.
I'm going to try this under linux using mount points, but I need to shuffle hardware first.
In response to
pgsql-performance by date
|Next:||From: Joe Conway||Date: 2002-12-09 21:48:21|
|Subject: Re: Speeding up aggregates|
|Previous:||From: Tom Lane||Date: 2002-12-09 21:26:32|
|Subject: Re: Speeding up aggregates |