On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote:
3) Estimate the size of the transaction log
** We've got no idea how to estimate this, need advice **
postgres doesn't have a 'transaction log', it has the WAL (Write-Ahead
Logs). These are typically 16MB each. on databases with a really heavy
write load, I might bump the checkpoint_segments as high as 60, which
seems to result in about 120 of them being created, 2GB total. these
files get reused, unless you are archiving them to implement a
continuous realtime backup system (which enables "PITR", Point in Time
Recovery)
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
