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 7129B529C9 for ; Mon, 18 Jul 2005 00:49:00 -0300 (ADT) 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 62150-09 for ; Mon, 18 Jul 2005 03:48:59 +0000 (GMT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id 307EC529AE for ; Mon, 18 Jul 2005 00:48:35 -0300 (ADT) Received: from ool-4353a8a5.dyn.optonline.net ([67.83.168.165] helo=[192.168.1.102]) by outbound.mailhop.org with esmtpa (Exim 4.51) id 1DuMcB-000Pcw-TX; Sun, 17 Jul 2005 23:48:23 -0400 X-Mail-Handler: MailHop Outbound by DynDNS.org X-Originating-IP: 67.83.168.165 X-Report-Abuse-To: abuse@dyndns.org (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut Message-ID: <42DB2684.9020706@zeut.net> Date: Sun, 17 Jul 2005 23:48:20 -0400 From: "Matthew T. O'Connor" User-Agent: Mozilla Thunderbird 1.0.2-1.3.3 (X11/20050513) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Robert Creager Cc: PGPerformance , Andy Hewitt Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - References: <20050717213416.59dcb52e@thunder.logicalchaos.org> In-Reply-To: <20050717213416.59dcb52e@thunder.logicalchaos.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/241 X-Sequence-Number: 13482 Robert Creager wrote: >For 8.03, pg_autovacuum is running. On 7.4.1, I set up a cron job to vacuum >analyze every 5 minutes. > > Are you sure that pg_autovacuum is doing it's job? Meaning are you sure it's vacuuming as often as needed? Try to run it with -d2 or so and make sure that it is actually doing the vacuuming needed.