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

Re: [NOVICE] VACUUM AND VACUUM ANALYSE

From: Thomas Good <tomg(at)q8(dot)nrnet(dot)org>
To: Mickaël Jouanne <m(dot)jouanne(at)apr-job(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] VACUUM AND VACUUM ANALYSE
Date: 2000-11-08 17:46:16
Message-ID: Pine.LNX.3.96.1001108124322.4034A-100000@q8.nrnet.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
On Wed, 8 Nov 2000, [iso-8859-1] Mickal 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"

Yes, it is a spelling difference.  
vacuum verbose analyze tabname;


> But cvdb is a working table.
> 
> Does someone have a idea of the error ?
> 
> thanks a lot !
> 
> -- 
> 
> Mickal JOUANNE
> Webmaster / Developpeur / Support Technique
> 
>      
> APR-Job &
> www.jobscout24.fr  - Meet your future
> _____________________________________
>    
> HumanLine France SAS
> 32, rue Pierret
> 92200 Neuilly
>    
> tel: +33 1 42 44 40 73
> fax: +33 1 49 26 09 76
> ICQ: 42799256
> m(dot)jouanne(at)humanline(dot)fr
> 


--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA                 Phone: 718-354-5528 
                                     Fax:   718-354-5056  
--------------------------------------------------------------------
Powered by:  PostgreSQL     s l a c k w a r e          FreeBSD:
               RDBMS       |---------- linux      The Power To Serve
--------------------------------------------------------------------


In response to

pgsql-novice by date

Next:From: Jim MercerDate: 2000-11-08 17:46:53
Subject: Re: VACUUM AND VACUUM ANALYSE
Previous:From: Mickaël JouanneDate: 2000-11-08 17:37:55
Subject: VACUUM AND VACUUM ANALYSE

pgsql-general by date

Next:From: Jim MercerDate: 2000-11-08 17:46:53
Subject: Re: VACUUM AND VACUUM ANALYSE
Previous:From: Mickaël JouanneDate: 2000-11-08 17:37:55
Subject: VACUUM AND VACUUM ANALYSE

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