On Wed, Jun 21, 2006 at 10:52:42AM -0300, jody brownell wrote: > A db wide vacuum full outputs this at the end. > > INFO: free space map contains 32848 pages in 159 relations > DETAIL: A total of 24192 page slots are in use (including overhead). > 24192 page slots are required to track all free space. > Current limits are: 4024000 page slots, 2000 relations, using 23705 KB. FWIW, the tail end of a db-wide vacuum FULL doesn't provide useful info about FSM utilization, because it just made everything as compact as possible. My suspicion is that it's taking too long for autovac to get around to this database/table. Dropping the sleep time might help. I see that this table is vacuumed with a delay setting of 0, but if there are other tables with a high delay that could pose a problem. Getting detailed output of what autovac is actually doing as Tom suggested would be a good idea. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
