| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Vivek Khera <vivek(at)khera(dot)org> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: autovacuum = on ignored |
| Date: | 2006-08-17 18:56:54 |
| Message-ID: | 20060817185654.GZ318@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vivek Khera wrote:
>
> On Aug 17, 2006, at 12:43 PM, Matthew T. O'Connor wrote:
>
> >Do you have row level stats enabled?
>
> is block level stats not sufficient for autovacuum?
>
> i'm seeing the same: "show all" tells me autovacuum is off, but it is
> for sure turned on in the postgresql.conf file and block level stats
> are on, but row level are not.
The server emitted a warning when the postmaster started because it
turned off autovacuum because row-level stats were off. So yeah,
block-level stats are not sufficient.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Walter Vaughan | 2006-08-17 19:27:26 | Newbie "Copy From" not working |
| Previous Message | Vivek Khera | 2006-08-17 18:32:20 | Re: autovacuum = on ignored |