| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Stephen Byers <stephenabyers(at)yahoo(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: autovacuum on updated rows |
| Date: | 2005-11-13 19:05:53 |
| Message-ID: | 20051113190553.GH29473@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Stephen Byers wrote:
> Sorry for noise. It turns out that little pound sign in front bit me !!
> #autovacuum = on
So, does it work after you activate it? Please note that there's a
threshold in the number of tuples that will need to be modified for
a vacuum operation to be launched. For such a small table you may want
to lower the threshold a bit. See the docs on the pg_autovacuum system
catalog, in the "internals" chapter.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F. O'Connell | 2005-11-14 03:05:13 | Re: Open connections details |
| Previous Message | Tomeh, Husam | 2005-11-11 23:35:51 | Re: read only user |