| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Schwenker, Stephen" <SSchwenker(at)thestar(dot)ca> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 8.2.3 AutoVacuum not running |
| Date: | 2007-04-09 19:06:19 |
| Message-ID: | 20070409190619.GL10785@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Schwenker, Stephen wrote:
> Hey,
>
> I've also notice one difference between my 8.1 instance and my 8.2
> instance. I run a ps and on the 8.1 instance there is a 'stats buffer
> process' and in the 8.2 instance there is no 'stats buffer instance'
>
> Does that give you anymore reasons as to why the autovacuum is not working?
No -- the stats buffer process was removed in 8.2 on purpose.
If you do a "show autovacuum", does it show as on? Maybe it was
disabled due to misconfiguration.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-04-09 19:08:43 | Re: plperl "set-valued function" problem |
| Previous Message | Bill Moran | 2007-04-09 19:05:42 | Re: Is there a shortage of postgresql skilled ops people |