Re: WAL Queries

RPK wrote:
> How to change the path of WAL? How much free space to leave on hard disk for
> effective performance? Since it is disabled by default, is it insignificant
> to ENABLE it?
>

Just change the settings under the WAL section of the config file. The
WAL files themselves will end up in the pg_xlog directory in pgdata, but
you can define the archive_command setting to archive the files off to
another directory.

Refer to the WAL section of the manual for details on what to set the
settings to.
http://www.postgresql.org/docs/8.2/interactive/wal-configuration.html

How much hard-disk space you need is largely dependant on the size of
your database and the size and frequency of updates coming through.

--
Paul Lambert
Database Administrator
AutoLedgers