I'm testing the new asynch commit feature on various raid
configurations and my early findings is that it reduces the impact of
keeping wal and data on the same volume. I have 10 disks to play
with, and am finding that it's faster to do a 10 drive raid 10 rather
than 8 drive raid 10 + two drive wal.
anybody curious about the results, feel free to drop a line. I think
this will be a popular feature.
pgsql-performance by date
|Next:||From: Dmitry Potapov||Date: 2007-08-23 14:37:39|
|Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux|
|Previous:||From: Russell Smith||Date: 2007-08-23 07:42:28|
|Subject: Re: Optimising "in" queries|