Re: Ordered Partitioned Table Scans

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Amit Langote <amitlangote09(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Antonin Houska <ah(at)cybertec(dot)at>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Ordered Partitioned Table Scans
Date: 2019-04-08 05:21:11
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2019/04/06 18:06, Julien Rouhaud wrote:
> On Sat, Apr 6, 2019 at 2:45 AM David Rowley
> <david(dot)rowley(at)2ndquadrant(dot)com> wrote:
>> On Sat, 6 Apr 2019 at 12:26, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> Pushed with some hacking, mostly trying to improve the comments.
>> Great! Many thanks for improving those and pushing it.
>> Many thanks to Julien, Antonin for their detailed reviews on this.
>> Thanks Amit for your input on this as well. Much appreciated.
> Thanks! I'm glad that we'll have this optimization for pg12.

+1, thank you for working on this. It's nice to see partitioning being
useful to optimize query execution in even more cases.


In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2019-04-08 05:22:17 RE: reloption to prevent VACUUM from truncating empty pages at the end of relation
Previous Message Andres Freund 2019-04-08 04:55:37 Re: lazy_scan_heap() forgets to mark buffer dirty when setting all frozen?