On Wed, May 25, 2011 at 1:08 PM, Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general