[rearranged to avoid top-posting: http://idallen.com/topposting.html]
Vipul Patel wrote:
> On Thursday 09 February 2012 10:33 PM, Kevin Grittner wrote:
>> What locks and blocking do you see when this happens?
>>
>> http://wiki.postgresql.org/wiki/Lock_Monitoring'
> I don't understand why " CREATE TABLE " Need to lock.
To protect the integrity of the system tables.
> CREATE TABLE Statement gose Hang state, whether it is execute by
> any client using (PQexec) or Standard "psql".
If you want suggestions on how to accomplish your goals in the
presence of this locking, we'll need more information.
-Kevin