vacuum analyze syntax in psql' help

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:

Oops, forgot to remove that second analyze.

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

Much better.

--
Bruce Momjian
maillist@candle.pha.pa.us

Bruce Momjian wrote:

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.

Will you fix this ?

How about the next:

Syntax:
vacuum [verbose] [analyze] [table]
or
vacuum [verbose] analyze table (attr1, ... attrN);

And this ?

Vadim

Done. Manual page, psql help, and error message fixed.

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

--
Bruce Momjian
maillist@candle.pha.pa.us