On Wed, May 25, 2011 at 1:08 PM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
> Note that "unneeded". Obviously, you need more than that, probably
> because you're restoring the database in one transaction (so none of
> the files can be flushed).
That's the way SQLServer and Oracle work, but not PostgreSQL. We can
clear down WAL files even during a long running transaction.
For us, "unneeded" means prior to the second-to-last checkpoint record.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services