tsuraan <tsuraan@gmail.com> writes:
> Is the WAL at the same location as the xlog (transaction log?)?
Same thing.
> The checkpoint_segments doc says increasing that value is really only
> useful if the xlog is separate from the data,
Dunno where you read that, but it's utter bilge. If you've got a
write-intensive workload, you want to crank checkpoint_segments as high
as you can stand. With the default settings on a modern machine it's
not hard at all to push it into checkpointing every dozen or seconds,
which will completely kill performance. (Disk space for pg_xlog/ and
potential delay during crash restart are the only negatives here. If
you are willing to push the average inter-checkpoint interval past five
minutes then you need to increase checkpoint_timeout too.)
regards, tom lane