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

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 (view raw or flat)
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

pgsql-performance by date

Next:From: A. KretschmerDate: 2007-01-23 10:53:35
Subject: Re: slow result
Previous:From: Laurent ManchonDate: 2007-01-23 10:34:52
Subject: slow result

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