Re: Moving pg_xlog

John A Meinel <john(at)arbash-meinel(dot)com> writes:
> Tom Lane wrote:
>> Now that I think about it, you were (if I understood your layout
>> correctly) proposing to put the xlog on your system's root disk.
>> This is probably a bad idea for performance, ...

> I certainly agree with what you wrote. But my understanding is that if
> you only have 2 arrays, then moving xlog onto the array not on the
> database is better than having it with the database. It isn't optimum,
> but it is better. Because that way there isn't as much contention
> between the database and xlog.

If the machine isn't doing much else than running the database, then
yeah, that may be the best available option. If there are other things
going on then you have to think about how much competition there is for
the root disk.

But the impression I had from the OP's df listing is that he has several
disks available ... so he ought to be able to find one that doesn't need
to do anything except xlog.

regards, tom lane