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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
