From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Cc: Laurent Manchon <lmanchon@univ-montp2.fr>
Subject: Re: slow result
Date: Tue, 23 Jan 2007 11:55:41 +0100
Message-ID: <20070123105541.GA13367@uio.no> (raw)
In-Reply-To: <5.0.2.1.2.20070123113422.00d189e8@pop.univ-montp2.fr>
References: <5.0.2.1.2.20070123113422.00d189e8@pop.univ-montp2.fr>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgunderson@bigfoot.com, lmanchon@univ-montp2.fr
Subject: Re: slow result
In-Reply-To: <20070123105541.GA13367@uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox