2016-12-02 17:10 GMT+13:00 Michael Paquier <michael.paqu...@gmail.com>:
> On Fri, Dec 2, 2016 at 1:04 PM, Melvin Davidson <melvin6...@gmail.com> > wrote: > > Well, while the location of pg_xlog is not currently configurable, on > Linux system the way to do it is to: > > 1. stop PostgreSQL > > 2. move the pg_xlog directory to a separate partition > > 3. create a symbolic link to point to the new partition > > 4. restart PostgreSQL > > Similar flow on Windows, just use a junction point for the link. > -- > Michael > I've done this on my Postgres 9.2 DB server running CentOS 6.7... And it's pretty much what the guys told you already: > 1. stop PostgreSQL > 2. move the pg_xlog directory to a separate partition > 3. create a symbolic link to point to the new partition > 4. restart PostgreSQL In my case, it significantly improved I/O performance. Lucas
