John R Pierce wrote:
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)
Thanks, I was using the term "transaction log" as a synonym for WAL.
We're planning on enabling PITR; how can we calculate the WAL size and
the WAL archive size in this case?
Regards,
Daniel Serodio
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
