<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
