From: Anibal David Acosta [mailto:aa(at)devshock(dot)com]
Sent: Thursday, October 04, 2012 10:01 AM
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.
This (lock escalation from row -> to page -> to table) is MS SQL Server "feature", pretty sure Postgres does not do it.
In response to
pgsql-performance by date
|Next:||From: Claudio Freire||Date: 2012-10-05 14:27:13|
|Subject: Re: how to avoid deadlock on masive update with multiples delete|
|Previous:||From: Colin Taylor||Date: 2012-10-05 00:34:43|
|Subject: Re: A Tale of 2 algorithms|