pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: James Pang (chaolpan) <chaolpan@cisco.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: partition pruning only works for select but update
Date: Fri, 01 Jul 2022 09:18:28 -0400
Message-ID: <712769.1656681508@sss.pgh.pa.us> (raw)
In-Reply-To: <20220701131311.GC13040@telsasoft.com>
References: <PH0PR11MB519134D4171A126776E3E063D6B89@PH0PR11MB5191.namprd11.prod.outlook.com>
	<2391513.1656423000@sss.pgh.pa.us>
	<PH0PR11MB519143DAE98DDDAC0E1AB717D6B89@PH0PR11MB5191.namprd11.prod.outlook.com>
	<PH0PR11MB5191A8D08D5B27D084BC6BFBD6BD9@PH0PR11MB5191.namprd11.prod.outlook.com>
	<20220701131311.GC13040@telsasoft.com>

Justin Pryzby <pryzby@telsasoft.com> writes:
> On Fri, Jul 01, 2022 at 08:30:40AM +0000, James Pang (chaolpan) wrote:
>> We have other application depend on V13, possible to backport code changes to V13 as https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=86dc90056dfdbd9d1b891718d2e5614e3e432f...

> In any case, I'm sure the feature won't be backpatched to v13 - it's an
> improvement but not a bugfix.

Even more to the point, it was an extremely major change and would take
a huge amount of QA effort to ensure that dropping it into v13 wouldn't
cause fresh problems.  The PG community has exactly no interest in making
such effort.

Besides which, what do you imagine "depends on v13" actually means?
If you have an app that works on v13 but not v14, maybe it's because
it depends on the old behavior in some way.

Spend your effort on updating your app, instead.

			regards, tom lane





view thread (7+ messages)  latest in thread

Message-ID: <712769.1656681508@sss.pgh.pa.us>
Permalink:  ../712769.1656681508@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/712769.1656681508@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pryzby@telsasoft.com, chaolpan@cisco.com, pgsql-performance@lists.postgresql.org
  Subject: Re: partition pruning only works for select but update
  In-Reply-To: <712769.1656681508@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox