Skip site navigation (1) Skip section navigation (2)

Re: slow result

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Laurent Manchon <lmanchon(at)univ-montp2(dot)fr>
Subject: Re: slow result
Date: 2007-01-23 10:55:41
Message-ID: 20070123105541.GA13367@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

  • slow result at 2007-01-23 10:34:52 from Laurent Manchon

Responses

pgsql-performance by date

Next:From: Steinar H. GundersonDate: 2007-01-23 10:58:04
Subject: Re: slow result
Previous:From: A. KretschmerDate: 2007-01-23 10:53:35
Subject: Re: slow result

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group