Обсуждение: 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 ______________________________