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