X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 86A5D53404 for ; Thu, 24 Mar 2005 23:40:53 +0000 (GMT) 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 09260-02 for ; Thu, 24 Mar 2005 23:40:48 +0000 (GMT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id 172AB53237 for ; Thu, 24 Mar 2005 23:40:47 +0000 (GMT) Received: from ool-4350c7ad.dyn.optonline.net ([67.80.199.173] helo=[192.168.0.66]) by outbound.mailhop.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.44) id 1DEbwX-000GIc-OL; Thu, 24 Mar 2005 18:40:49 -0500 Message-ID: <42434FFC.10105@zeut.net> Date: Thu, 24 Mar 2005 18:40:44 -0500 From: "Matthew T. O'Connor" Organization: Terrie O'Connor Realtors User-Agent: Mozilla Thunderbird 1.0RC1 (Windows/20041201) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Otto Blomqvist Cc: pgsql-performance@postgresql.org Subject: Re: pg_autovacuum not having enough suction ? References: <4933.1111692779@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Mail-Handler: MailHop Outbound by DynDNS.org X-Originating-IP: 67.80.199.173 X-Report-Abuse-To: abuse@dyndns.org (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/524 X-Sequence-Number: 11229 The version that shipped with 8.0 should be fine. The only version that had the problem Tom referred to are in the early 7.4.x releases. Did you get my other message about information from the stats system (I'm not sure why my other post has yet to show up on the performance list). Matthew Otto Blomqvist wrote: >Sorry about that. I'm Running 8.0.0 on Linux Redhat 8.0 > > >"Tom Lane" wrote in message >news:4933.1111692779@sss.pgh.pa.us... > > >>"Otto Blomqvist" writes: >> >> >>>Over 100'000 Index Rows removed, 300'000 unused item pointers ? How >>> >>> >could > > >>>autovacuum let this happen ? >>> >>> >>What PG version is this? >> >>(The earlier autovacuum releases had some bugs with large tables, thus >>the question...) >> >>regards, tom lane >> >>---------------------------(end of broadcast)--------------------------- >>TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org >> >> >> > > > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > >