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
