> Try breaking down the A query with LIMIT/OFFSET so that it never holds
> locks for long. That way B will not wait for long, if at all, and will
> not fail.
Just as a remark, this will only work if the chunks can be processed in
separate transactions. If the whole thing is related and A must be
completely wrapped in a transaction, then the locks placed by the first
queries will still hold until the end of the transaction...
Cheers,
Csaba.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
