Jim C. Nasby wrote: > On Wed, Jun 21, 2006 at 01:21:05PM -0300, jody brownell wrote: >> Jun 21 13:04:04 vanquish postgres[3311]: [19-1] DEBUG: "target": removed >> 5645231 row versions in 106508 pages >> Jun 21 13:04:04 vanquish postgres[3311]: [19-2] DETAIL: CPU 3.37s/1.23u sec >> elapsed 40.63 sec. >> Jun 21 13:04:04 vanquish postgres[3311]: [20-1] DEBUG: "target": found >> 5645231 removable, 1296817 nonremovable row versions in 114701 pages >> Jun 21 13:04:04 vanquish postgres[3311]: [20-2] DETAIL: 0 dead row versions >> cannot be removed yet. > > So the table contained 5.6M dead rows and 1.3M live rows. > > I think you should forget about having autovacuum keep this table > in-check and add manual vacuum commands to your code. Autovac is > intended to deal with 99% of use cases; this is pretty clearly in the 1% > it can't handle.
Maybe your free space map is configured to small, can you watch out for log messages telling to increase it? 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly