Re: Vacuum goes worse

Поиск
Список
Период
Сортировка
От Stéphane Schildknecht
Тема Re: Vacuum goes worse
Дата
Msg-id 4716FAFF.7020104@postgresqlfr.org
обсуждение исходный текст
Ответ на Re: Vacuum goes worse  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance
Scott Marlowe a écrit :
> On 10/17/07, Stéphane Schildknecht
> <stephane.schildknecht@postgresqlfr.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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Stéphane Schildknecht
Дата:
Сообщение: Re: Vacuum goes worse
Следующее
От: Nis Jørgensen
Дата:
Сообщение: Re: Incorrect estimates on columns