Re: how to avoid deadlock on masive update with multiples delete

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: Anibal David Acosta <aa(at)devshock(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: how to avoid deadlock on masive update with multiples delete
Date: 2012-10-05 14:06:41
Message-ID: A76B25F2823E954C9E45E32FA49D70EC08EB763C@mail.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

From: Anibal David Acosta [mailto:aa(at)devshock(dot)com]
Sent: Thursday, October 04, 2012 10:01 AM
To: pgsql-performance(at)postgresql(dot)org
Subject: how to avoid deadlock on masive update with multiples delete

.....
.....
.....

The other situation could be that update process while blocking rows scale to block page and the try to scale to lock table while the delete process as some locked rows.

Thanks!

This (lock escalation from row -> to page -> to table) is MS SQL Server "feature", pretty sure Postgres does not do it.

Regards,
Igor Neyman

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2012-10-05 14:27:13 Re: how to avoid deadlock on masive update with multiples delete
Previous Message Colin Taylor 2012-10-05 00:34:43 Re: A Tale of 2 algorithms