Re: [GENERAL] Interpreting pg_locks; looking for deadlock

2006-01-26 Thread Michael Fuhr
On Tue, Jan 24, 2006 at 04:35:59PM -0500, [EMAIL PROTECTED] wrote: > I have a postgresql 7.4.8 database which has the same table > declarations in several schemas. My application accesses each schema > from a single thread; there is never more than one thread accessing a > schema at a time. > > To

[GENERAL] Interpreting pg_locks; looking for deadlock

2006-01-24 Thread jao
I have a postgresql 7.4.8 database which has the same table declarations in several schemas. My application accesses each schema from a single thread; there is never more than one thread accessing a schema at a time. To try increasing concurrency, I've tried using multiple threads per schema. The