X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B0DA3D1B897 for ; Tue, 27 Apr 2004 08:42:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 37939-09 for ; Tue, 27 Apr 2004 08:42:16 -0300 (ADT) Received: from anchor-post-37.mail.demon.net (anchor-post-36.mail.demon.net [194.217.242.86]) by svr1.postgresql.org (Postfix) with ESMTP id 2C500D1B8BD for ; Tue, 27 Apr 2004 08:42:13 -0300 (ADT) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-37.mail.demon.net with esmtp (Exim 3.35 #1) id 1BIQye-0006v1-0b; Tue, 27 Apr 2004 12:42:16 +0100 Date: Tue, 27 Apr 2004 12:42:13 +0100 From: Paul Thomas To: "Michael L . Hostbaek" Cc: "pgsql-sql @ postgresql . org" Subject: Re: Performance issue Message-ID: <20040427124213.A11703@bacon> References: <20040427091252.GA93126@mich2.itxmarket.com> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <20040427091252.GA93126@mich2.itxmarket.com>; from mich@the-lab.org on Tue, Apr 27, 2004 at 10:12:52 +0100 X-Mailer: Balsa 1.2.3 Lines: 20 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/296 X-Sequence-Number: 17671 On 27/04/2004 10:12 Michael L. Hostbaek wrote: > [snip] > Is this normal ? If I run the same select on another table in the same > database with ~40.000 rows, it takes approx 820.00ms... You would probably get better answers on the correct list but my guess is that your fsm setting might be too low for the number of dead tuples you are trying to reclaim so the vacuum is not clearing all the dead stuff out. There's plenty of stuff about this in the archives and the docs. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+