Re: VACUUM ANALYZE

Michael Ben-Nes <miki@canaan.co.il>

From: "Ben-Nes Michael" <miki@canaan.co.il>
To: "Andras Balogh" <abalogh@grafx.ro>, <pgsql-general@postgresql.org>
Date: 2001-07-17T15:33:36Z
Lists: pgsql-general
nope, all my db (2) are extremly small (new) and I have 500 mb free


----- Original Message ----- 
From: "Andras Balogh" <abalogh@grafx.ro>
To: "Ben-Nes Michael" <miki@canaan.co.il>; <pgsql-general@postgresql.org>
Sent: Tuesday, July 17, 2001 4:27 PM
Subject: Re: [GENERAL] VACUUM ANALYZE 


> Hi,
> 
> What about not having any free space left on
> your hard drive?
> I just found out that a vacuum analyze will use
> many hard disk space.
> In my case in requires allmost 2.0 GB.
> Does anybody know why ?
> 
> 
> Keep in touch,
> 
> Andras. 
> 
> ----- Original Message ----- 
> From: "Ben-Nes Michael" <miki@canaan.co.il>
> To: <pgsql-general@postgresql.org>
> Sent: Tuesday, July 17, 2001 3:02 PM
> Subject: [GENERAL] VACUUM ANALYZE 
> 
> 
> > 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
--------------------------