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:
"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
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-06-24 13:50:00|
|Subject: Re: symlinking pg_xlog |
|Previous:||From: sandhya||Date: 2005-06-24 13:34:21|
|Subject: reg:libpqxx on windows|