From: Anibal David Acosta [mailto:a...@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 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
