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

help / color / mirror / Atom feed
From: Justin Pryzby <pryzby@telsasoft.com>
To: Ronnie S <ronniesan967@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12
Date: Sun, 22 Mar 2020 23:10:41 -0500
Message-ID: <20200323041041.GH2563@telsasoft.com> (raw)
In-Reply-To: <CAG89ABgnToyZuNNJx+rYt1ySu-8+C6KdEKAvkELJx2eGDJW4JQ@mail.gmail.com>
References: <CAG89ABgnToyZuNNJx+rYt1ySu-8+C6KdEKAvkELJx2eGDJW4JQ@mail.gmail.com>

On Sun, Mar 22, 2020 at 11:45:53PM -0400, Ronnie S wrote:
> Hello All,
> 
> While doing some tests with hash partitioning behavior in PG11 and 12, I
> have found that PG11 is not performing partition pruning with DELETEs
> (explain analyze returned >2000 lines). I then ran the same test in PG12
> and recreated the objects using the same DDL, and it worked

> Is this a bug, somewhat related to MergeAppend?
> https://github.com/postgres/postgres/commit/5220bb7533f9891b1e071da6461d5c387e8f7b09

> If it is, anyone know if we have a workaround for DELETEs to use hash
> partitions in PG11?

I think due to this commit to pg12:
https://commitfest.postgresql.org/22/1778/
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=428b260f87e8861ba8e58807b69d433db491c...
...
https://www.postgresql.org/message-id/5c83dbca-12b5-1acf-0e85-58299e464a26%40lab.ntt.co.jp
https://www.postgresql.org/message-id/4f049572-9440-3c99-afa1-f7ca7f38fe80%40lab.ntt.co.jp

-- 
Justin





view thread (3+ messages)  latest in thread

Message-ID: <20200323041041.GH2563@telsasoft.com>
Permalink:  ../20200323041041.GH2563@telsasoft.com/
Also on:    postgresql.org/message-id/20200323041041.GH2563@telsasoft.com

 · 

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: pryzby@telsasoft.com, ronniesan967@gmail.com, pgsql-performance@lists.postgresql.org
  Subject: Re: Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12
  In-Reply-To: <20200323041041.GH2563@telsasoft.com>

* 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