Re: autovacuum on updated rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Byers <stephenabyers(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: autovacuum on updated rows
Date: 2005-11-11 20:38:35
Message-ID: 21367.1131741515@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Stephen Byers <stephenabyers(at)yahoo(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas F. O'Connell 2005-11-11 20:44:44 Re: Could not create unique index, table contains duplicated values
Previous Message Jaime Casanova 2005-11-11 20:37:40 Re: autovacuum on updated rows