On Tue, 2008-07-08 at 13:09 +0500, Dmitry Melekhov wrote: > Hello! > > I tried to ask this question in novice list. > Just because there are no replies I try here. > This is really novice question- I'm oracle dba :-) > > > I just installed 8.3 with WAL enabled. > > But I can't understand why postgres generated many archive logs during > > vacuum, if WAL is enabled. > > Could you explain?
What do you mean "WAL is enabled"? That's not a term I recognize since WAL is always enabled. Best read this http://developer.postgresql.org/pgdocs/postgres/routine-vacuuming.html VACUUM needs to perform writes to clear up, which generates WAL. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
