Re: Draft LIMIT pushdown to Append and MergeAppend patch

Поиск
Список
Период
Сортировка
От Andy Fan
Тема Re: Draft LIMIT pushdown to Append and MergeAppend patch
Дата
Msg-id CAKU4AWpSHwfr1PNk30hxjD75V+nTraeApJ-SHx7K8EeSpbAMBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Draft LIMIT pushdown to Append and MergeAppend patch  (Michał Kłeczek <michal@kleczek.org>)
Ответы Re: Draft LIMIT pushdown to Append and MergeAppend patch
Список pgsql-hackers
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: CREATE DATABASE with filesystem cloning
Следующее
От: Noah Misch
Дата:
Сообщение: Re: Unlogged relation copy is not fsync'd