On Wed, May 25, 2011 at 6:37 AM, Simon Riggs <simon@xxxxxxxxxxxxxxx> wrote: > 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. I wonder if OP is outrunning his checkpoint writing? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
