Re: [HACKERS] [Proposal] Make the optimiser aware of partitions ordering

Поиск
Список
Период
Сортировка
От Ronan Dunklau
Тема Re: [HACKERS] [Proposal] Make the optimiser aware of partitions ordering
Дата
Msg-id 2701654.FqDTblohPo@ronan_laptop
обсуждение исходный текст
Ответ на Re: [HACKERS] [Proposal] Make the optimiser aware of partitions ordering  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [HACKERS] [Proposal] Make the optimiser aware of partitions ordering  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Re: [HACKERS] [Proposal] Make the optimiser aware of partitionsordering  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
On lundi 20 mars 2017 15:52:03 CET Robert Haas wrote:
> On Mon, Mar 20, 2017 at 6:31 AM, Ronan Dunklau <ronan.dunklau@dalibo.com> 
wrote:
> > With range partitioning, we guarantee that each partition contains non-
> > overlapping values. Since we know the range allowed for each partition, it
> > is possible to sort them according to the partition key (as is done
> > already for looking up partitions).
> > 
> > Thus, we ca generate sorted Append plans instead of MergeAppend when
> > sorting occurs on the partition key.
> 
> Great idea.  This is too late for v10 at this point, but please add it
> to the next CommitFest so we don't forget about it.

I know it is too late, and thought that it was too early to add it to the 
commitfest properly since so many design decisions should be discussed. Thanks 
for the feedback, I added it.


-- 
Ronan Dunklau
http://dalibo.com - http://dalibo.org



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavan Deolasee
Дата:
Сообщение: Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [HACKERS] Re: [COMMITTERS] pgsql: Improve pg_dump regressiontests and code coverage