Re: slow result

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.rupp@redhat.com, http://www.dpunkt.de/buch/ 
3-89864-429-4.html