Dmitry Melekhov wrote: > 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?
VACUUM changes the database, and these changes go to the transaction log. If VACUUM changes a lot, you can end up with many archived WAL files. There's no correspondence in Oracle, but think of it as an "ALTER TABLE <name> MOVE" except that there is no NOLOGGING clause. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
