VACCUM VERBOSE ANALYZE

Поиск
Список
Период
Сортировка
От Cédric BUSCHINI
Тема VACCUM VERBOSE ANALYZE
Дата
Msg-id 4469C0AD.60802@carax.com
обсуждение исходный текст
Ответы Re: VACCUM VERBOSE ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hello,

I would like to save in a file log from a "VACUUM VERBOSE analyze" perform from psql.
I ve tried different ways :
--------------
[USER@DBsrv] # psql -c'VACUUM VERBOSE analyze' > /home/log_vaccum
--------------
the same command in a script without the '> /home/log_vaccum'
[USER@DBsrv] # vaccum.sh > /home/log_vaccum
--------------
[USER@DBsrv]# psql
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

DBsrv=# VACUUM VERBOSE analyze; \o /home/log_vaccum
--------------

.....
but no one worked :(

The log file is created but empty.

Does any one got an idea ?

Cheers

Cedric

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

Предыдущее
От: Verena Ruff
Дата:
Сообщение: tools analyzing EXPLAIN
Следующее
От: Tom Lane
Дата:
Сообщение: Re: VACCUM VERBOSE ANALYZE