vacuum analyze syntax in psql' help
| От | Vadim B. Mikheev |
|---|---|
| Тема | vacuum analyze syntax in psql' help |
| Дата | |
| Msg-id | 34D697E8.67AA497@sable.krasnoyarsk.su обсуждение исходный текст |
| Ответы |
Re: vacuum analyze syntax in psql' help
Re: vacuum analyze syntax in psql' help |
| Список | pgsql-hackers |
vac=> \h vacuum
Command: vacuum
Description: vacuum the database, i.e. cleans out deleted records, updates statistics
Syntax:
vacuum [verbose] [analyze]
or
vacuum [verbose] [analyze] table [analyze [(attr1, ... attrN)] ];
^^^^^^^
Imho, new ANALYZE syntax with attributes is quite unclear to me:
vac=> vacuum x (y);
PQexec() -- Request was sent to backend, but backend closed the channel before responding.
This probably means the backend terminated abnormally before or while processing the request.
How about the next:
Syntax:
vacuum [verbose] [analyze] [table]
or
vacuum [verbose] analyze table (attr1, ... attrN);
Vadim
В списке pgsql-hackers по дате отправления: