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
[EMAIL PROTECTED], http://www.dpunkt.de/buch/
3-89864-429-4.html
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match