Jason Long wrote:
I am planning on setting up PITR for my application.
I also have to ship them off site using a T1 so setting the time to
automatically switch files will just waste bandwidth if they are still
going to be 16 MB anyway.
*1. What is the effect of recompiling and reducing the default size of
the WAL files?
Increased I/O
2. What is the minimum suggested size?
16 megs, the default.
3. If I reduce the size how will this work if I try to save a document
that is larger than the WAL size?
You will create more segments.
Joshua D. Drake
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
