applications hang when calling 'vacuum'
Show quoted text
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
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
----------------------------------