| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "richyen3(at)gmail(dot)com" <richyen3(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: autovacuum vacuums entire database...is this right? |
| Date: | 2007-06-03 22:17:34 |
| Message-ID: | 20070603221734.GB3813@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
richyen3(at)gmail(dot)com escribió:
> It's been about a month and a half, and I'm getting this VACUUM
> again. This time, I'm wondering if there's any way to tell if
> autovacuum is doing a database-wide vacuum for the sake of xid
> wraparound or for some other reason. Is there some sort of entry that
> gets put into the log, and if so, what log level would it be at?
No, I don't think we had yet set more extensive logging in autovacuum.
> If this doesn't get logged, could I make this a feature request?
Not really, because starting from 8.2 autovacuum no longer does that.
There is no longer a need for database-wide vacuums. So if you're
having problems because of that, your best bet is to upgrade.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas 'ads' Scherbaum | 2007-06-03 22:34:44 | Re: New Live CD needed |
| Previous Message | Jeff Davis | 2007-06-03 22:10:27 | Re: multimaster |