Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id EE2389FB878 for ; Tue, 16 Oct 2007 13:03:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 79633-10 for ; Tue, 16 Oct 2007 13:03:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 269339FB89E for ; Tue, 16 Oct 2007 13:03:19 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l9GG3GjA018250; Tue, 16 Oct 2007 12:03:17 -0400 (EDT) To: "Scott Marlowe" cc: "=?ISO-8859-1?Q?St=E9phane_Schildknecht?=" , "pgsql-performance@postgresql.org" Subject: Re: Vacuum goes worse In-reply-to: References: <47147AD8.9010704@postgresqlfr.org> <15640.1192544768@sss.pgh.pa.us> <4714D817.30701@postgresqlfr.org> Comments: In-reply-to "Scott Marlowe" message dated "Tue, 16 Oct 2007 10:43:34 -0500" Date: Tue, 16 Oct 2007 12:03:16 -0400 Message-ID: <18249.1192550596@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/191 X-Sequence-Number: 27213 "Scott Marlowe" writes: > On 10/16/07, St=E9phane Schildknecht > wrote: >> That's also why I am so disappointed vacuum doesn't give me these 4 >> hints lines. > What kind of error, or output, does it give you at the end? Any hint > as to why they're missing? If you're talking about the FSM statistics display, that only gets printed by a database-wide VACUUM (one that doesn't name a specific table). regards, tom lane