On Fri, Jul 15, 2011 at 4:36 AM, Tony Wang <wwwjfy@xxxxxxxxx> wrote: > Weird that I receive your each message twice. > On Fri, Jul 15, 2011 at 15:33, Radoslaw Smogura <rsmogura@xxxxxxxxxxxxxxx> > wrote: >> >> Simple and obvious question right now do You call commit after >> transaction? If yes do you use any query or connection pooler? > > Yes. connection pool is used as application level, not db level. > no commit after transaction is possible (I'm trying to check the logic), I > just cannot imagine it happened for so many users at the same time, and then > calmed down for long time, and came again. > I found the query I used to log locks would miss locks that relname is null. > will add that, though no idea why it's null They're likely exclusive locks on a transaction, which are normal. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
