>> Unfortunately though if there is heavy load, the wal files will be generated more regularly than the 5 minute max.
> If you wrote the WAL to an external, mounted disk, wouldn't that solve the issue?
What I'm trying to say is that I configured it to keep (60/5) * 24 segments plus a few spare, because I am switching
xlogevery 5 mins. But if there is heavy load then they will be generated more often than every 5 mins, so that number
won'tbe enough.
But I think it's a moot point because they seem to be useless unless you have all of them up to the last base backup.
Whichto me indicates I need to do a base backup every day...?
Cheers, jamie
===============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
===============================================================================