Date: Tue, 23 Jan 2007 11:55:41 +0100
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Cc: Laurent Manchon <lmanchon@univ-montp2.fr>
Subject: Re: slow result
Message-ID: <20070123105541.GA13367@uio.no>
Mail-Followup-To: pgsql-performance@postgresql.org,
	Laurent Manchon <lmanchon@univ-montp2.fr>
References: <5.0.2.1.2.20070123113422.00d189e8@pop.univ-montp2.fr>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <5.0.2.1.2.20070123113422.00d189e8@pop.univ-montp2.fr>
User-Agent: Mutt/1.5.13 (2006-08-11)

On Tue, Jan 23, 2007 at 11:34:52AM +0100, Laurent Manchon wrote:
> I have a slow response of my PostgreSQL database 7.4 using this query below
> on a table with 800000 rows:
> 
> select count(*)from tbl;

Contrary to your expectations, this is _not_ a query you'd expect to be fast
in Postgres. Try real queries from your application instead -- most likely,
you'll find them to be much master. (If not, come back with the query, the
schema and the EXPLAIN ANALYZE output of your query, and you'll usually get
help nailing down the issues. :-) )

/* Steinar */
-- 
Homepage: http://www.sesse.net/