I am planning on setting up PITR for my application.
It does not see much traffic and it looks like the 16 MB log files
switch about every 4 hours or so during business hours.
I am also about to roll out functionality to store documents in a bytea
column. This should make the logs roll faster.
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?
2. What is the minimum suggested size?
3. If I reduce the size how will this work if I try to save a document
that is larger than the WAL size?
Any other suggestions would be most welcome.
Thank you for your time,
CEO and Chief Software Engineer
BS Physics, MS Chemical Engineering
HJBug Founder and President
In response to
pgsql-hackers by date
|Next:||From: Suresh||Date: 2008-10-29 03:16:33|
|Subject: Checking stack depth|
|Previous:||From: Alvaro Herrera||Date: 2008-10-29 01:37:15|
|Subject: Re: PostgreSQL + Replicator developer meeting 10/28|
pgsql-general by date
|Next:||From: x asasaxax||Date: 2008-10-29 02:36:12|
|Subject: Problem with sql|
|Previous:||From: Tom Lane||Date: 2008-10-29 01:16:20|
|Subject: Re: UUID-OSSP Contrib Module Compilation Issue |