Re: VACUUM ANALYZE

No lock :(

I tried it on 2 dbs , both very small and new.



----- Original Message ----- 
From: "Fabrice Scemama" <gesnet@scemama.org>
To: "Ben-Nes Michael" <miki@canaan.co.il>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, July 18, 2001 6:39 PM
Subject: Re: [GENERAL] VACUUM ANALYZE 


> You might suffer from a deadlock.
> 
> On Tue, 17 Jul 2001, Ben-Nes Michael wrote:
> 
> > Hi All
> > 
> > VACUUM ANALYZE;
> > 
> > return me the next error:
> > 
> > pqReadData() -- backend closed the channel unexpectedly.
> >         This probably means the backend terminated abnormally
> >         before or while processing the request.
> > The connection to the server was lost. Attempting reset: Failed.
> > 
> > Any ideas ?
> > 
> > --------------------------
> > Canaan Surfing Ltd.
> > Internet Service Providers
> > Ben-Nes Michael - Manager
> > Tel: 972-4-6991122
> > http://sites.canaan.co.il
> > --------------------------