<vipul.patel@elitecore.com> wrote:
> some time call of create table is stuck which is called by PQexec.
What locks and blocking do you see when this happens?
http://wiki.postgresql.org/wiki/Lock_Monitoring'
Have you considered getting an explicit lock with NOWAIT at the
start of your transaction, to test whether you can currently acquire
the rights to proceed?
> in current stat the PQexec will stuck till anyone not vacume and
> reindexing the DB.
I've never seen such a situation. Are you sure that's really
needed, as opposed to something that just takes long enough that the
issue has cleared by the time you're finished with these steps?
-Kevin