Skip site navigation (1) Skip section navigation (2)

Re: VACUUM AND VACUUM ANALYSE

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: Mickaƫl Jouanne <m(dot)jouanne(at)apr-job(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: VACUUM AND VACUUM ANALYSE
Date: 2000-11-08 21:27:34
Message-ID: 200011082127.QAA11284@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
Ok, it will now accept ANALYSE in the current source tree.


[ Charset ISO-8859-1 unsupported, converting... ]
> =?iso-8859-1?Q?Micka=EBl_Jouanne?= wrote:
>   >Hello !
>   >
>   >I want to do a VACUUM ANALYSE on some tables but when i do :
>   >
>   >EDEN=> VACUUM ANALYSE cvdb;
>   >ERROR:  parser: parse error at or near "cvdb"
>   >
>   >But cvdb is a working table.
>   >
>   >Does someone have a idea of the error ?
>  
> 
> It's "ANALYZE" (those Americans just don't know how to spell!)
> 
> 
> -- 
> Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "And whosoever liveth and believeth in me shall never 
>       die. Believest thou this?"    John 11:26 
> 
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-novice by date

Next:From: Charles CurleyDate: 2000-11-08 22:20:29
Subject: Re: [NOVICE] Re: VACUUM AND VACUUM ANALYSE
Previous:From: Poul KristensenDate: 2000-11-08 20:36:54
Subject: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc

pgsql-general by date

Next:From: Mikheev, VadimDate: 2000-11-08 21:30:11
Subject: RE: Really SLOW using GROUP BY ...!?
Previous:From: Tom LaneDate: 2000-11-08 21:26:44
Subject: Re: Really SLOW using GROUP BY ...!?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group