> some time call of create table is stuck which is called by PQexec.
What locks and blocking do you see when this happens?
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?
In response to
pgsql-bugs by date
|Next:||From: John R Pierce||Date: 2012-02-09 18:44:13|
|Subject: Re: BUG #6451: problem while installing gridsql|
|Previous:||From: Duncan Rance||Date: 2012-02-09 15:07:09|
|Subject: Re: BUG #6425: Bus error in slot_deform_tuple |