X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 521B3D9CF0 for ; Fri, 11 Nov 2005 17:12:01 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53978-09 for ; Fri, 11 Nov 2005 21:11:58 +0000 (GMT) X-Greylist: delayed 00:06:39.372722 by SQLgrey- Received: from web30714.mail.mud.yahoo.com (web30714.mail.mud.yahoo.com [68.142.201.252]) by svr1.postgresql.org (Postfix) with SMTP id 9C9B7D9CD1 for ; Fri, 11 Nov 2005 17:11:59 -0400 (AST) Received: (qmail 94873 invoked by uid 60001); 11 Nov 2005 21:05:20 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=HAVgFqNhByLVCHYJYBjLTQvbO+aJ2pB6VnSwbzz8TOyD52/09Sflh3lk2KdnbNpf5yy3lvjEKAWpRU10Irmt30/a+0t4Wdbl8IEFlezvmnYXYUXBojlyNLPUw8e1KEBHIDq7IXCi8wnYwkc/zByApMvmcmI+iiNE75VZJUC+GqU= ; Message-ID: <20051111210520.94871.qmail@web30714.mail.mud.yahoo.com> Received: from [216.127.142.194] by web30714.mail.mud.yahoo.com via HTTP; Fri, 11 Nov 2005 13:05:20 PST Date: Fri, 11 Nov 2005 13:05:20 -0800 (PST) From: Stephen Byers Subject: Re: autovacuum on updated rows To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <21367.1131741515@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-882284963-1131743120=:93364" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.36 required=5 tests=[AWL=-0.120, DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.36 X-Spam-Level: X-Archive-Number: 200511/145 X-Sequence-Number: 19518 --0-882284963-1131743120=:93364 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Sorry for noise. It turns out that little pound sign in front bit me !! #autovacuum = on Tom Lane 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. --0-882284963-1131743120=:93364 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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. --0-882284963-1131743120=:93364--