Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: autovacuum on updated rows
Date
Msg-id 21367.1131741515@sss.pgh.pa.us
Whole thread Raw
In response to autovacuum on updated rows  (Stephen Byers <stephenabyers@yahoo.com>)
Responses Re: autovacuum on updated rows  (Stephen Byers <stephenabyers@yahoo.com>)
List pgsql-admin
Tree view 
Stephen Byers <stephenabyers@yahoo.com> 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

pgsql-admin by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: autovacuum on updated rows
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: Could not create unique index, table contains duplicated values