Search Postgresql Archives

Re: How can I set a timeout for a locked table in Function ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How can I set a timeout for a locked table in Function ?
From: Thomas Kellerer <spam_eater@xxxxxxx>
Date: Fri, 3 Jan 2020 19:05:41 +0100
In-reply-to: <CAHOFxGrzeUf3=9M9z_AFJz9PfHfETHpke5bwM6PMMXRkfc_EOQ@mail.gmail.com>
References: <CALcdmySuZO9OsFOC6-7gPN4PfmLe1W2y_pmxPfjMthWAH-qYNA@mail.gmail.com> <VI1PR0501MB266933A9E57F7FDD74E619F9EF230@VI1PR0501MB2669.eurprd05.prod.outlook.com> <CAHOFxGrzeUf3=9M9z_AFJz9PfHfETHpke5bwM6PMMXRkfc_EOQ@mail.gmail.com>
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666

Michael Lewis schrieb am 03.01.2020 um 18:00:

Why take an exclusive lock on an entire table to update a single row?


That's what I was asking myself as well.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How can I set a timeout for a locked table in Function ?
  - From: Jeff Janes

References:
- How can I set a timeout for a locked table in Function ?
  - From: İlyas Derse
- RE: How can I set a timeout for a locked table in Function ?
  - From: Patrick FICHE
- Re: How can I set a timeout for a locked table in Function ?
  - From: Michael Lewis

Prev by Date: Re: How can I set a timeout for a locked table in Function ?
Next by Date: Are PostgreSQL functions that return sets or tables evaluated lazily or eagerly?
Previous by thread: Re: How can I set a timeout for a locked table in Function ?
Next by thread: Re: How can I set a timeout for a locked table in Function ?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux