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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html