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