Skip site navigation (1) Skip section navigation (2)

Re: Vacuum goes worse

From: Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Vacuum goes worse
Date: 2007-10-18 06:19:43
Message-ID: 4716FAFF.7020104@postgresqlfr.org (view raw or flat)
Thread:
Lists: pgsql-performance
Scott Marlowe a écrit :
> On 10/17/07, Stéphane Schildknecht
> <stephane(dot)schildknecht(at)postgresqlfr(dot)org> 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


In response to

pgsql-performance by date

Next:From: Nis JørgensenDate: 2007-10-18 09:29:08
Subject: Re: Incorrect estimates on columns
Previous:From: Stéphane SchildknechtDate: 2007-10-18 06:17:27
Subject: Re: Vacuum goes worse

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group