Re: Help with count(*) - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: Help with count(*)
Date
Msg-id 200311141300.34397.shridhar_daithankar@myrealbox.com
Whole thread Raw
In response to Help with count(*)  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-performance
On Friday 14 November 2003 12:51, Rajesh Kumar Mallah wrote:
> Hi ,
>
> my database seems to be taking too long for a select count(*)
> i think there are lot of dead rows. I do a vacuum full it improves
> bu again the performance drops in a short while ,
> can anyone please tell me if anything worng with my fsm settings
> current fsm=55099264 (not sure how i calculated it)

If you don't need exact count, you can use statistics. Just analyze frequently
and you will get the statistics.

and I didn't exact;y understand this in the text.

INFO:  "profiles": found 0 removable, 369195 nonremovable row versions in
43423 pages
DETAIL:  246130 dead row versions cannot be removed yet.

Is there a transaction holoding up large amount of stuff?

 Shridhar


pgsql-performance by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Help with count(*)
Next
From: Slavisa Garic
Date:
Subject: INSERT extremely slow with large data sets (fwd)