Postgres Pro
Downloads
Home   >   mailing lists

Re: Draft LIMIT pushdown to Append and MergeAppend patch - Mailing list pgsql-hackers

From Andy Fan
Subject Re: Draft LIMIT pushdown to Append and MergeAppend patch
Date
Msg-id CAKU4AWpSHwfr1PNk30hxjD75V+nTraeApJ-SHx7K8EeSpbAMBA@mail.gmail.com
Whole thread Raw
In response to Re: Draft LIMIT pushdown to Append and MergeAppend patch  (Michał Kłeczek <michal@kleczek.org>)
Responses Re: Draft LIMIT pushdown to Append and MergeAppend patch
List pgsql-hackers
Tree view


On Sun, Oct 8, 2023 at 5:04 AM Michał Kłeczek <michal@kleczek.org> wrote:
Hi All,

Attached is a second version of the patch.

The goal is to:
1. Apply LIMIT as early as possible - especially to apply LIMIT in partition scans

For the patches for performance improvement,  it is better to provide
an example to show how much benefits we can get.  As for this case,
I'm doubtful it can work as an improvement. 

2. Enable LIMIT pushdown for FDW partitions.

The same as above,  some testing is helpful. 
 
--
Best Regards
Andy Fan

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: CREATE DATABASE with filesystem cloning
Next
From: Noah Misch
Date:
Subject: Re: Unlogged relation copy is not fsync'd