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

From Barnes, Sandy (Sandra)
Subject applications hang when calling 'vacuum'
Date
Msg-id 4B3EBD3B46D7D21194B30008C7B1C76508CD7269@OLTEX134
Whole thread Raw
Responses Re: applications hang when calling 'vacuum'  (Denis Perchine <dyp@perchine.com>)
List pgsql-hackers
> 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
> 


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [GENERAL] Re: Hardcopy docs available
Next
From: Tom Lane
Date:
Subject: Re: RI oddness