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
Try increasing it.
Btw, VACUUM outputs a Warning if FSM is not high enough, maybe you can
find useful hints in the log file.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
In response to
pgsql-performance by date
|Next:||From: Greg Quinn||Date: 2006-03-28 12:14:00|
|Subject: Slow performance on Windows .NET and OleDb|
|Previous:||From: Simon Riggs||Date: 2006-03-28 08:30:54|
|Subject: Re: simple join uses indexes, very slow|