vacuum analyze syntax in psql' help

From: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>
To: maillist(at)candle(dot)pha(dot)pa(dot)us, hackers(at)postgreSQL(dot)org
Subject: vacuum analyze syntax in psql' help
Date: 1998-02-03 04:07:04
Message-ID: 34D697E8.67AA497@sable.krasnoyarsk.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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:

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message James Hughes 1998-02-03 04:17:48 Re: [HACKERS] VACUUM ANALYZE Problem
Previous Message Bruce Momjian 1998-02-03 03:17:41 Re: [HACKERS] subquery syntax broken