Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8CAE79FA2EC; Thu, 28 Dec 2006 13:18:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 67508-02; Thu, 28 Dec 2006 13:17:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from presinet.com (mail.presinet.com [209.53.156.1]) by postgresql.org (Postfix) with ESMTP id CE2869F95E3; Thu, 28 Dec 2006 13:17:53 -0400 (AST) Received: from [10.10.1.151] ([10.10.1.151]) by presinet.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 28 Dec 2006 09:16:41 -0800 Message-ID: <4593FC3F.8020207@presinet.com> Date: Thu, 28 Dec 2006 09:17:51 -0800 From: Bricklen Anderson User-Agent: Thunderbird 1.5.0.8 (X11/20061117) MIME-Version: 1.0 To: Cedric BUSCHINI CC: Novice Postgresql-list , pgsql-admin@postgresql.org Subject: Re: Performances References: <4593958B.1040601@carax.com> In-Reply-To: <4593958B.1040601@carax.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 28 Dec 2006 17:16:41.0234 (UTC) FILETIME=[F0DC1720:01C72AA3] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/348 X-Sequence-Number: 24140 Cedric BUSCHINI wrote: > Hello everyone, > > A quick question: > - how long does it take you to perform that query : > "SELECT COUNT(*) FROM A_TABLE;" > Not long :) dev5=# SELECT COUNT(*) FROM A_TABLE; ERROR: relation "a_table" does not exist