On 12/01/2016 07:00 AM, rob...@interactive.co.uk wrote:
The following documentation comment has been logged on the website:


In various places (e.g. stackoverflow), I've seen people suggest having
pg_xlog ion a different disk (i.e. not in /var/lib/pgsql/9.X/data).

The only mention of this that I've seen is in Section 29.5 (WAL Internals),
and that just says "it is advantageous...", with no explanation.

If this IS a good idea, then "Server Configuration / File Locations" 
where it should be discussed: in particular, why is it a good idea, and how
does it affect backups (and in particular base backups to a standby server).

The reason it can be advantageous is that pg_xlog has a different write profile that $PGDATA. The WAL is written sequentially versus randomly.


Command Prompt, Inc.                  http://the.postgres.company/
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.

Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:

Reply via email to