Postgres Pro
Downloads
Home   >   mailing lists

Re: how to avoid deadlock on masive update with multiples delete - Mailing list pgsql-performance

From Igor Neyman
Subject Re: how to avoid deadlock on masive update with multiples delete
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC08EB763C@mail.corp.perceptron.com
Whole thread Raw
In response to how to avoid deadlock on masive update with multiples delete  ("Anibal David Acosta" <aa@devshock.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Colin Taylor
Date:
Subject: Re: A Tale of 2 algorithms
Next
From: Claudio Freire
Date:
Subject: Re: how to avoid deadlock on masive update with multiples delete