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.pa...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
