Re: Delay locking partitions during INSERT and UPDATE

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Delay locking partitions during INSERT and UPDATE
Date: 2019-02-18 22:56:22
Message-ID: CAKJS1f8zTEaYxX_yPNcbj3ZJReVXhpJ+9nrrHdo-36R10H5AXg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 19 Feb 2019 at 11:47, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Are we talking about the same patch? The one I'm looking at seems
> to be mostly planner and plancache changes:
>
> src/backend/catalog/dependency.c | 1 +
> src/backend/commands/createas.c | 1 +
> src/backend/executor/execUtils.c | 20 +++++++++++---------
> src/backend/nodes/copyfuncs.c | 1 +
> src/backend/nodes/equalfuncs.c | 1 +
> src/backend/nodes/outfuncs.c | 1 +
> src/backend/nodes/readfuncs.c | 1 +
> src/backend/optimizer/plan/planner.c | 2 ++
> src/backend/optimizer/util/inherit.c | 11 +++++++++++
> src/backend/parser/parse_relation.c | 2 ++
> src/backend/replication/logical/worker.c | 1 +
> src/backend/rewrite/rewriteHandler.c | 1 +
> src/backend/utils/adt/ri_triggers.c | 2 ++
> src/backend/utils/adt/ruleutils.c | 3 +++
> src/backend/utils/cache/plancache.c | 15 +++++++++++----
> src/include/nodes/parsenodes.h | 2 ++

Looks like you're looking at the patch from the "Delay locking
partitions during query execution" thread [1]. Different thing
altogether, although the names are confusingly similar.

[1] https://commitfest.postgresql.org/22/1897/

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2019-02-18 23:13:48 Re: Inadequate executor locking of indexes
Previous Message Andres Freund 2019-02-18 22:53:27 Re: Delay locking partitions during INSERT and UPDATE