| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Gábriel Ákos <akos(dot)gabriel(at)i-logic(dot)hu> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: count(*) performance |
| Date: | 2006-03-28 11:49:45 |
| Message-ID: | 442922D9.1020402@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Gábriel Ákos wrote:
> I thought that too. Autovacuum is running on our system but it didn't do
> the trick. Anyway the issue is solved, thank you all for helping. :)
Hi, Gabriel, it may be that your Free Space Map (FSM) setting is way to
low.
Try increasing it.
Btw, VACUUM outputs a Warning if FSM is not high enough, maybe you can
find useful hints in the log file.
HTH
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Quinn | 2006-03-28 12:14:00 | Slow performance on Windows .NET and OleDb |
| Previous Message | Simon Riggs | 2006-03-28 08:30:54 | Re: simple join uses indexes, very slow |