X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 931C411F6067 for ; Fri, 28 Apr 2006 14:37:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 67720-02 for ; Fri, 28 Apr 2006 14:37:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hotmail.com (bay101-f30.bay101.hotmail.com [64.4.56.40]) by postgresql.org (Postfix) with ESMTP id 9045D11F602F for ; Fri, 28 Apr 2006 14:37:36 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 28 Apr 2006 10:37:35 -0700 Message-ID: Received: from 64.4.56.200 by by101fd.bay101.hotmail.msn.com with HTTP; Fri, 28 Apr 2006 17:37:30 GMT X-Originating-IP: [84.210.10.106] X-Originating-Email: [bealach_na_bo@hotmail.com] X-Sender: bealach_na_bo@hotmail.com In-Reply-To: <20060428145842.GI97354@pervasive.com> From: "Bealach-na Bo" To: jnasby@pervasive.com Cc: pgsql-performance@postgresql.org Subject: Re: Why so slow? Date: Fri, 28 Apr 2006 17:37:30 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 28 Apr 2006 17:37:35.0417 (UTC) FILETIME=[6F9E3A90:01C66AEA] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/679 X-Sequence-Number: 18763 >The above shows that the indexes contained 10M rows and 160M of dead >space each. That means you weren't vacuuming nearly enough. How is it that a row in the table can grow to a size far exceeding the sum of the maximum sized of the fields it consists of? >13M dead rows, and the table is 1.4M pages, or 11GB. No wonder it's >slow. I had a look at the disk files and they are HUGE indeed. > >You need to run a vacuum full, and then you need to vacuum far more >often. If you're running 8.1, turn on autovacuum and cut each default >scale factor in half, to 0.2 and 0.1. I'm not runing 8.1. Is there a way of doing this in 8.0 or do I need to write a shell script + cron job? Regards, Bealach