Postgres Pro
Downloads
Home   >   mailing lists

Re: Delay locking partitions during INSERT and UPDATE - Mailing list pgsql-hackers

From John Naylor
Subject Re: Delay locking partitions during INSERT and UPDATE
Date
Msg-id CACPNZCskY7Zm1HRcOOBJPHTQ+Ydsyz_LS0vhmrENmRNodqXWYA@mail.gmail.com
Whole thread Raw
In response to Re: Delay locking partitions during INSERT and UPDATE  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: Delay locking partitions during INSERT and UPDATE  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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?

-- 
John Naylor                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Almost bug in COPY FROM processing of GB18030 encoded input
Next
From: Tomas Vondra
Date:
Subject: Re: Delay locking partitions during INSERT and UPDATE