| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> | 
|---|---|
| To: | vadim(at)sable(dot)krasnoyarsk(dot)su (Vadim B(dot) Mikheev) | 
| Cc: | hackers(at)postgreSQL(dot)org | 
| Subject: | Re: vacuum analyze syntax in psql' help | 
| Date: | 1998-02-03 19:25:04 | 
| Message-ID: | 199802031925.OAA21704@candle.pha.pa.us | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
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(at)candle(dot)pha(dot)pa(dot)us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-02-03 19:25:56 | Re: [HACKERS] VACUUM ANALYZE Problem | 
| Previous Message | The Hermit Hacker | 1998-02-03 18:46:22 | Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page |