Re: vacuum analyze syntax in psql' help
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: vadim@sable.krasnoyarsk.su (Vadim B. Mikheev)
Cc: hackers@postgreSQL.org
Date: 1998-02-03T04:33:59Z
Lists: 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: 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