| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Dmitry Melekhov <dm(at)belkam(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: please explain vacuum with WAL |
| Date: | 2008-07-08 08:36:12 |
| Message-ID: | 1215506172.4051.714.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Melekhov | 2008-07-08 08:54:57 | Re: please explain vacuum with WAL |
| Previous Message | Dushyanth | 2008-07-08 08:30:26 | Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Melekhov | 2008-07-08 08:54:57 | Re: please explain vacuum with WAL |
| Previous Message | Dmitry Melekhov | 2008-07-08 08:09:06 | please explain vacuum with WAL |