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

Reply via email to