Re: Help with count(*)
| От | Shridhar Daithankar |
|---|---|
| Тема | Re: Help with count(*) |
| Дата | |
| Msg-id | 200311141300.34397.shridhar_daithankar@myrealbox.com обсуждение |
| Ответ на | Help with count(*) (Rajesh Kumar Mallah <mallah@trade-india.com>) |
| Список | 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 по дате отправления: