Re: Delay locking partitions during INSERT and UPDATE

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Delay locking partitions during INSERT and UPDATE
Дата
Msg-id 1273e3f0-1f72-3859-d460-534241e8a1c1@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Delay locking partitions during INSERT and UPDATE  (John Naylor <john.naylor@2ndquadrant.com>)
Ответы Re: Delay locking partitions during INSERT and UPDATE  (Robert Haas <robertmhaas@gmail.com>)
Re: Delay locking partitions during INSERT and UPDATE  (John Naylor <john.naylor@2ndquadrant.com>)
Список pgsql-hackers

On 1/24/19 10:34 PM, John Naylor wrote:
> On Thu, Jan 24, 2019 at 4:17 PM Tomas Vondra
> <tomas.vondra@2ndquadrant.com> wrote:
>> I can still see about the same performance as before (on both clusters).
> 
> Thanks for checking! I think the thing to do now is have a committer
> look at it. It's a small patch with obvious performance effects --
> there's just the question of whether the locking behavior with
> concurrent DDL is as safe as it is now.
>
> Anyone have anything else?
>

Yes, I don't see why would the patch change that and I've been looking
for such cases. I think David was looking at that this week too, and I
assume he'll send an update if he finds anything. If not, I plan to get
it committed soon-ish (possibly next week after the FOSDEM dev meeting,
unless there are some objections).

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-hackers по дате отправления:

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: Delay locking partitions during INSERT and UPDATE
Следующее
От: Andres Freund
Дата:
Сообщение: Old protocol fastpath calls borked?