Skip site navigation (1) Skip section navigation (2)

Re: symlinking pg_xlog

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
Cc: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: symlinking pg_xlog
Date: 2005-06-24 13:40:38
Message-ID: 20050624134038.GA45058@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Jun 24, 2005 at 03:18:12PM +0200, KÖPFERL Robert wrote:
> 
> due to I/O-bottle necks I think of making a symlink from pg_xlog to another
> physical disk.
> This is a modification inside the cluster dir. What kind of idea is that?
> bad one?

See the "Write-Ahead Logging (WAL)" chapter in the documentation:

http://www.postgresql.org/docs/8.0/static/wal-internals.html

"It is of advantage if the log is located on another disk than the
main database files.  This may be achieved by moving the directory
pg_xlog to another location (while the server is shut down, of
course) and creating a symbolic link from the original location in
the main data directory to the new location."

Several third-party performance-tuning documents make the same
recommendation.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2005-06-24 13:50:00
Subject: Re: symlinking pg_xlog
Previous:From: sandhyaDate: 2005-06-24 13:34:21
Subject: reg:libpqxx on windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group