| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | Amit Langote <amitlangote09(at)gmail(dot)com> |
| Cc: | PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Record a Bitmapset of non-pruned partitions |
| Date: | 2021-07-12 02:47:24 |
| Message-ID: | CAApHDvrdoN_sXU52i=QDXe2k3WAo=EVry29r2+Tq2WYcn2xhEA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, 10 Jul 2021 at 03:24, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
> The good news is that the code in partitions_are_ordered() became even
> more simple as a result of this change. We can do ordered scan simply
> when !bms_overlap(live_parts, boundinfo->interleaved_parts).
I've spent a bit more time revising the 0002 patch so that we're a bit
more strict about when we mark a partition as interleaved. For
example, if the DEFAULT partition happens to be the only partition,
then I'm no longer classing that as interleaved as there's nothing for
it to be interleaved with.
This also fixes up the not-so-robust check that I had to check if the
NULL partition allowed other Datums.
David
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0001-Track-non-pruned-partitions-in-RelOptInfo.patch | application/octet-stream | 8.2 KB |
| v3-0002-Allow-ordered-partition-scans-in-more-cases.patch | application/octet-stream | 20.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2021-07-12 03:08:55 | Re: Diagnostic comment in LogicalIncreaseXminForSlot |
| Previous Message | Michael Paquier | 2021-07-12 02:16:10 | Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers. |