Обсуждение: 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: 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
> > 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