Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 87B049FA0FD for ; Mon, 24 Sep 2007 12:38:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 52849-03 for ; Mon, 24 Sep 2007 12:38:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from globalrelay.com (mail1.globalrelay.com [204.92.49.200]) by postgresql.org (Postfix) with ESMTP id 39AED9FA0D1 for ; Mon, 24 Sep 2007 12:38:36 -0300 (ADT) X-Virus-Scanned: Scanned by GRC-AntiVirus Gateway Received: from [63.231.179.95] (HELO davedell) by globalrelay.com (CommuniGate Pro SMTP 4.2.3) with ESMTP id 158367060; Mon, 24 Sep 2007 15:38:35 +0000 From: "Dave Dutcher" To: =?iso-8859-1?Q?'G=E1bor_Farkas'?= Cc: References: <46F7C494.1050604@nekomancer.net> <46F7C9F1.1080805@enterprisedb.com> <46F7D207.3000901@nekomancer.net> <46F7D2C7.70105@enterprisedb.com> <46F7D453.4050908@nekomancer.net> Subject: Re: select count(*) performance (vacuum did not help) Date: Mon, 24 Sep 2007 10:37:42 -0500 Message-ID: <02d201c7fec0$d95a2cd0$cb00a8c0@tridecap.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acf+vfcGa4Hk/lPnQ8aMBJ8MzRxAxwAAoDuw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 In-Reply-To: <46F7D453.4050908@nekomancer.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/427 X-Sequence-Number: 26972 > -----Original Message----- > From: G=E1bor Farkas >=20 >=20 > i see. >=20 > will i achieve the same thing by simply dropping that table=20 > and re-creating it? Yes. Or even easier (if you don't need the data anymore) you can use = the truncate command. Which deletes everything in the table including dead rows. Dave