Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum on updated rows - Mailing list pgsql-admin

From Stephen Byers
Subject Re: autovacuum on updated rows
Date
Msg-id 20051111210520.94871.qmail@web30714.mail.mud.yahoo.com
Whole thread Raw
In response to Re: autovacuum on updated rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: autovacuum on updated rows  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Tree view
Sorry for noise.  It turns out that little pound sign in front bit me !!
#autovacuum = on

Tom Lane <tgl@sss.pgh.pa.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.

pgsql-admin by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: Re: Could not create unique index, table contains duplicated values
Next
From: "Tomeh, Husam"
Date:
Subject: Re: read only user