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