Hi,
I don't understand why " CREATE TABLE " Need to lock.
CREATE TABLE Statement gose Hang state, whether it is execute by any
client using (PQexec) or Standard "psql".
Regards,
Vipul Patel.
On Thursday 09 February 2012 10:33 PM, Kevin Grittner wrote:
> <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
>
>
