Thread

1. applications hang when calling 'vacuum'

   Barnes, Sandy (Sandra) <sandy.barnes@honeywell.com> — 2001-04-26T16:36:51Z

   > 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
   > 
   
   

2. Re: applications hang when calling 'vacuum'

   Denis Perchine <dyp@perchine.com> — 2001-04-27T03:23:39Z

   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
   ----------------------------------