On 2/28/05 6:53 PM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > Again, VACUUM VERBOSE info would be informative (it's sufficient to look > at your larger tables for this). It took 5.2 hours again tonight to do the vacuum. I don't see anything out of the ordinary - no explanation for the non-linear increases in vacuum time. This is what shows up at the end: INFO: free space map: 93 relations, 282 pages stored; 1712 total pages needed DETAIL: Allocated FSM size: 1000 relations + 1000000 pages = 5920 kB shared memory. The tables all show something like: INFO: "blah": found 0 removable, 366326534 nonremovable row versions in 3241829 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages are entirely empty. Wes ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
