Re: Non-overlapping updates blocking each other

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Non-overlapping updates blocking each other
Date: 2017-10-14 16:01:27
Message-ID: ortcce$52o$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Melvin Davidson schrieb am 14.10.2017 um 17:32:
> More than likely, the optimizer has determined that a table scan is best, in which case it will use a table lock.
> That means one updates will be blocking each other.

Since when does Postgres lock the whole table during an update?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-10-14 16:07:38 Re: Non-overlapping updates blocking each other
Previous Message Melvin Davidson 2017-10-14 15:32:31 Re: Non-overlapping updates blocking each other