
> 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?
> 
> Sandy Barnes
> email    sandy.barnes@honeywell.com
> 

Thu, 26 Apr 2001 09:36:51 -0700
"Barnes, Sandy (Sandra)" <Sandy.Barnes@Honeywell.com>
applications hang when calling 'vacuum' 
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
----------------------------------

Fri, 27 Apr 2001 10:23:39 +0700
Denis Perchine <dyp@perchine.com>
Re: applications hang when calling 'vacuum'