Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group