Re: slow result

From: "Heiko W(dot)Rupp" <heiko(dot)rupp(at)redhat(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow result
Date: 2007-01-23 10:43:16
Message-ID: 08E18820-41DF-4170-A39E-B5DFAAF1C690@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Am 23.01.2007 um 11:34 schrieb Laurent Manchon:

> Hi,
>
> 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;

count(*) is doing a full tablescan over all your 800000 rows. This is
a well known "feature"
of postgres :-/

So enhancing the performance is currently only possible by having
faster disk drives.
--
Heiko W.Rupp
heiko(dot)rupp(at)redhat(dot)com, http://www.dpunkt.de/buch/
3-89864-429-4.html

In response to

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

Browse pgsql-performance by date

  From Date Subject
Next Message A. Kretschmer 2007-01-23 10:53:35 Re: slow result
Previous Message Laurent Manchon 2007-01-23 10:34:52 slow result