Обсуждение: VACUUM ANALYSE

hello,

this command (VACUUM ANALYSE) doesn't work with my 6.5.2 postgres......

error message:
NOTICE:  Vacuum: table not found

any suggestion?
--
______________________________
 Arnaud FLORENT
 IRIS Technologies

 phone: (33) 03 20 65 85 80
 fax: (33) 03 20 65 85 81
 GSM: (33) 06 15 14 32 90

 mailto:aflorent@iris-tech.fr
______________________________

Arnaud FLORENT wrote:
>
> this command (VACUUM ANALYSE) doesn't work with my 6.5.2 postgres......
>
> error message:
> NOTICE:  Vacuum: table not found

Try VACUUM ANALYZE... :)
                ^
Cheers,
Ed Loehr

On Tue, Feb 01, 2000 at 04:33:57PM +0100, Arnaud FLORENT wrote:
> hello,
>
> this command (VACUUM ANALYSE) doesn't work with my 6.5.2 postgres......
>
> error message:
> NOTICE:  Vacuum: table not found
>
> any suggestion?

Did the spell analyse analyze suggestions work? If so, great, but for me

rfb=# \d
      List of relations
   Name   | Type  |  Owner
----------+-------+----------
 computer | table | postgres
...
rfb=# vacuum analyze computer;
NOTICE:  Vacuum: table not found
VACUUM


still looking...

Patrick

Patrick Welche a écrit :

> On Tue, Feb 01, 2000 at 04:33:57PM +0100, Arnaud FLORENT wrote:
> > hello,
> >
> > this command (VACUUM ANALYSE) doesn't work with my 6.5.2 postgres......
> >
> > error message:
> > NOTICE:  Vacuum: table not found
> >
> > any suggestion?
>
> Did the spell analyse analyze suggestions work? If so, great, but for me

yes, it worked fine.....
thanks all.

>
>
> rfb=# \d
>       List of relations
>    Name   | Type  |  Owner
> ----------+-------+----------
>  computer | table | postgres
> ...
> rfb=# vacuum analyze computer;
> NOTICE:  Vacuum: table not found
> VACUUM
>
> still looking...
>
> Patrick
>
> ************

--
______________________________
 Arnaud FLORENT
 IRIS Technologies

 phone: (33) 03 20 65 85 80
 fax: (33) 03 20 65 85 81
 GSM: (33) 06 15 14 32 90

 mailto:aflorent@iris-tech.fr
______________________________