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

From: Anibal David Acosta [mailto:aa@devshock.com]
Sent: Thursday, October 04, 2012 10:01 AM
To: pgsql-performance@postgresql.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
tablewhile 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