[GENERAL] Database Select Slow

[carter ck]

Hi all,

I am facing a performance issue here. Whenever I do a count(*) on a table 
that contains about 300K records, it takes few minutes to complete. Whereas 
my other application which is counting > 500K records just take less than 10 
seconds to complete.

I have indexed all the essential columns and still it does not improve the 
speed.

All helps and advice are appreciated.

Thanks.

_________________________________________________________________
Check it out! Windows Live Spaces is here! http://spaces.live.com/?mkt=en-sg 
It’s easy to create your own personal Web site.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq