Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BC57A9FBC76 for ; Thu, 5 Apr 2007 02:47:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 60119-07 for ; Thu, 5 Apr 2007 02:47:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 33E4F9FBC74 for ; Thu, 5 Apr 2007 02:47:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l355l3vb019566; Thu, 5 Apr 2007 01:47:03 -0400 (EDT) To: "A. Kretschmer" cc: pgsql-sql@postgresql.org Subject: Re: slow query In-reply-to: <20070405053637.GC24814@a-kretschmer.de> References: <7539aebb0704042017l70d83d53u9c2e5105620a3fa7@mail.gmail.com> <20070405051127.GA24814@a-kretschmer.de> <19157.1175750845@sss.pgh.pa.us> <20070405053637.GC24814@a-kretschmer.de> Comments: In-reply-to "A. Kretschmer" message dated "Thu, 05 Apr 2007 07:36:38 +0200" Date: Thu, 05 Apr 2007 01:47:03 -0400 Message-ID: <19565.1175752023@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/67 X-Sequence-Number: 28067 "A. Kretschmer" writes: > am Thu, dem 05.04.2007, um 1:27:25 -0400 mailte Tom Lane folgendes: >> I'm betting the problem is poor vacuuming practice leading to lots of >> dead space. There's no way it takes 22 sec to read 10 rows if the >> table is reasonably dense. > This was my first thought, but: > ,----[ Quote ] > | I've tried > | vacuuming this table many time > `---- [ shrug... ] If the damage is already done, lazy VACUUM won't fix it. regards, tom lane