| From: | Stephen Byers <stephenabyers(at)yahoo(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: autovacuum on updated rows |
| Date: | 2005-11-11 21:05:20 |
| Message-ID: | 20051111210520.94871.qmail@web30714.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Sorry for noise. It turns out that little pound sign in front bit me !!
#autovacuum = on
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
Stephen Byers writes:
> Will autovacuum eventually run on this table????
Um ... is autovacuum actually turned on? (It's not by default.)
Check the pg_stat_ views to see if the updates are getting counted in
the statistics for the table.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomeh, Husam | 2005-11-11 23:35:51 | Re: read only user |
| Previous Message | Thomas F. O'Connell | 2005-11-11 20:44:44 | Re: Could not create unique index, table contains duplicated values |