On Fri, Jul 15, 2011 at 12:38, John R Pierce <pie...@hogranch.com> wrote:
> On 07/14/11 7:58 PM, Tony Wang wrote: > >> >> There were 2519 RowExclusiveLock and 85 ExclusiveLock >> > > how could 800 max_connections have 2519 row locks ? do you update multiple > different rows in the same transaction? > > the row locks includes indexes locks, also some updates related to two tables. Roughly, about 700+ unique RowExclusiveLock there > > > > -- > john r pierce N 37, W 122 > santa cruz ca mid-left coast > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> >
