| From: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Help with count(*) |
| Date: | 2003-11-14 07:30:34 |
| Message-ID: | 200311141300.34397.shridhar_daithankar@myrealbox.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Slavisa Garic | 2003-11-14 07:36:41 | INSERT extremely slow with large data sets |
| Previous Message | Rajesh Kumar Mallah | 2003-11-14 07:21:38 | Help with count(*) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Slavisa Garic | 2003-11-14 09:38:33 | INSERT extremely slow with large data sets (fwd) |
| Previous Message | Rajesh Kumar Mallah | 2003-11-14 07:21:38 | Help with count(*) |