Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id EB2499FB565 for ; Wed, 17 Oct 2007 08:33:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 89247-03 for ; Wed, 17 Oct 2007 08:33:06 -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 F1FD29FB6C0 for ; Wed, 17 Oct 2007 08:33:08 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by dalibo-free-72.custom.lost-oasis.net (Postfix) with ESMTP id 25030578072 for ; Wed, 17 Oct 2007 13:33:07 +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 WL2DSMSN-hij for ; Wed, 17 Oct 2007 13:33:07 +0200 (CEST) Received: by dalibo-free-72.custom.lost-oasis.net (Postfix, from userid 1011) id 01B0E578076; Wed, 17 Oct 2007 13:33:06 +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 9B63A578072 for ; Wed, 17 Oct 2007 13:33:02 +0200 (CEST) Message-ID: <4715F2ED.20604@postgresqlfr.org> Date: Wed, 17 Oct 2007 13:33:01 +0200 From: =?ISO-8859-1?Q?St=E9phane_Schildknecht?= User-Agent: Thunderbird 1.5.0.13 (X11/20070824) MIME-Version: 1.0 To: "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> In-Reply-To: <18249.1192550596@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/196 X-Sequence-Number: 27218 Tom Lane a écrit : > "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). > 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. The output ends with: INFO: vacuuming "public.sometable" INFO: "sometable": removed 62 row versions in 3 pages DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: "sometable": found 62 removable, 5 nonremovable row versions in 5 pages DETAIL: 0 dead row versions cannot be removed yet. There were 534 unused item pointers. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: analyzing "public.sometable" INFO: "sometable": scanned 5 of 5 pages, containing 5 live rows and 0 dead rows; 5 rows in sample, 5 estimated total rows VACUUM Best regards, Stéphane