Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B4FBA9FBEC1 for ; Thu, 18 Oct 2007 03:19:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39335-10 for ; Thu, 18 Oct 2007 03:19:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from dalibo-free-72.custom.lost-oasis.net (unknown [212.85.154.72]) by postgresql.org (Postfix) with ESMTP id D0EE09FBEBE for ; Thu, 18 Oct 2007 03:19:49 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by dalibo-free-72.custom.lost-oasis.net (Postfix) with ESMTP id D1501578072; Thu, 18 Oct 2007 08:19:47 +0200 (CEST) Received: from dalibo-free-72.custom.lost-oasis.net ([127.0.0.1]) by localhost (pyrrha.dalibo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id eltPa8Jw0M67; Thu, 18 Oct 2007 08:19:47 +0200 (CEST) Received: by dalibo-free-72.custom.lost-oasis.net (Postfix, from userid 1011) id B61E0578076; Thu, 18 Oct 2007 08:19:47 +0200 (CEST) Received: from [192.168.1.100] (lns-bzn-50f-81-56-152-169.adsl.proxad.net [81.56.152.169]) by dalibo-free-72.custom.lost-oasis.net (Postfix) with ESMTP id 2B543578072; Thu, 18 Oct 2007 08:19:45 +0200 (CEST) Message-ID: <4716FAFF.7020104@postgresqlfr.org> Date: Thu, 18 Oct 2007 08:19:43 +0200 From: =?ISO-8859-1?Q?St=E9phane_Schildknecht?= User-Agent: Thunderbird 1.5.0.13 (X11/20070824) MIME-Version: 1.0 To: Scott Marlowe CC: "pgsql-performance@postgresql.org" Subject: Re: Vacuum goes worse References: <47147AD8.9010704@postgresqlfr.org> <15640.1192544768@sss.pgh.pa.us> <4714D817.30701@postgresqlfr.org> <18249.1192550596@sss.pgh.pa.us> <4715F2ED.20604@postgresqlfr.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/217 X-Sequence-Number: 27239 Scott Marlowe a écrit : > On 10/17/07, Stéphane Schildknecht > wrote: > >> Tom Lane a écrit : >> >> Yes, I am. The command line is (in a shell script whom ouput is >> redirected in a global file) : >> >> vacuumdb -d $DBNAME -p $DBPORT -U $DBUSR -z -v >> >> >> That does not explain why we don't get FSM statitics display. >> > > Hmmm. Have you tried running that command interactively? I'm just > wondering if your redirect is somehow dropping bits of the output. > I tried a few combinations of redirection tests to verify that, and always get all of the output or none of it. According to Tom and tests I made on another box, superuser is the key. Thanks anyway. Best regards, -- Stéphane SCHILDKNECHT Président de PostgreSQLFr http://www.postgresqlfr.org