Re: applications hang when calling 'vacuum' - Mailing list pgsql-hackers

From Denis Perchine
Subject Re: applications hang when calling 'vacuum'
Date
Msg-id 20010427031433.A6A4E1C6E5@mx.webmailstation.com
Whole thread Raw
In response to applications hang when calling 'vacuum'  ("Barnes, Sandy (Sandra)" <Sandy.Barnes@Honeywell.com>)
List pgsql-hackers
On Thursday 26 April 2001 23:36, Barnes, Sandy (Sandra) wrote:
> > We are currently calling 'vacuum' from within our code, using the psql++
> > PgDatabase ExecCommandOk() to send the SQL statement 'vacuum'.  I seems
> > to work when we only have one process running, but when two processes
> > (both invoking the vacuum) are running it immediately hangs.  Some
> > postgres processes exist... one 'idle' and one 'VACUUM'.  The
> > applications hang. I tried using the PgTransaction class to invoke the
> > SQL but received an error stating that vacuum cannot be run in a
> > transaction.
> > Any ideas?

Can confirm this. This is also the case on my systems. I already told about 
this some time ago. There was no reply...

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: PAM Authentication for PostgreSQL...
Next
From: Hiroshi Inoue
Date:
Subject: 7.1 startup recovery failure