X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 593AA9FA5FC for ; Tue, 27 Jun 2006 21:50:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 24967-10 for ; Tue, 27 Jun 2006 21:50:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 745549F9DCC for ; Tue, 27 Jun 2006 21:50:35 -0300 (ADT) Received: from [10.82.1.60] (docboy.decibel.org [65.86.67.34]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 5F4735644B; Tue, 27 Jun 2006 19:50:32 -0500 (CDT) In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <9F858089-CCD2-4F88-BA18-8738ECEF5246@pervasive.com> Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: strange fsm issues Date: Tue, 27 Jun 2006 19:22:01 -0500 To: Jeff Frost X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/266 X-Sequence-Number: 22228 On Jun 23, 2006, at 5:31 PM, Jeff Frost wrote: > On Thu, 22 Jun 2006, Jeff Frost wrote: >> On Thu, 22 Jun 2006, Jim Nasby wrote: >>>> CPU 0.00s/0.00u sec elapsed 0.00 sec. >>>> INFO: free space map contains 3339998 pages in 125 relations >>>> DETAIL: A total of 3341600 page slots are in use (including >>>> overhead). >>>> 3341600 page slots are required to track all free space. >>>> Current limits are: 3366499 page slots, 2000 relations, using >>>> 19853 KB. > > So, now after setting it so high and seeing the above output, we > ran vacuum verbose again today to check it and it looks like this now: > > CPU 0.00s/0.00u sec elapsed 0.00 sec. > INFO: free space map contains 27804 pages in 125 relations > DETAIL: A total of 29600 page slots are in use (including overhead). > 29600 page slots are required to track all free space. > Current limits are: 3366499 page slots, 2000 relations, using > 19853 KB. > > What the heck? Why would it have shrunk down so much? The vacuum > full isn't scheduled until tonight. :-/ Take a look at the source for autovacuum... I'm guessing you're right and that it doesn't make any special considerations for toast tables, which it probably should (since AFAIK you have to first vacuum the base table, then commit, then vacuum the toast table). BTW, tracking pg_class.relpages or actual file size over time would probably be helpful. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461