Thread

1. vacuum analyze syntax in psql' help

   Vadim Mikheev <vadim@sable.krasnoyarsk.su> — 1998-02-03T04:07:04Z

   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
   
   

2. Re: vacuum analyze syntax in psql' help

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-03T04:33:59Z

   > 
   > 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
   
   

3. Re: [HACKERS] Re: vacuum analyze syntax in psql' help

   Vadim Mikheev <vadim@sable.krasnoyarsk.su> — 1998-02-03T05:11:03Z

   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
   
   

4. Re: vacuum analyze syntax in psql' help

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-03T19:25:04Z

   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