Re: [HACKERS] Secondary index access optimizations

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: [HACKERS] Secondary index access optimizations
Дата
Msg-id
20171204164437.lqjpeawybmrg7lw6@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
[HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Antonin Houska <ah@cybertec.at>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Antonin Houska <ah@cybertec.at>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Antonin Houska <ah@cybertec.at>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Andres Freund <andres@anarazel.de>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Secondary index access optimizations David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] Secondary index access optimizations David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Secondary index access optimizations Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Secondary index access optimizations Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Secondary index access optimizations Pantelis Theodosiou <ypercube@gmail.com>
Konstantin Knizhnik wrote:
> 
> 
> On 30.11.2017 05:16, Michael Paquier wrote:
> > On Mon, Nov 6, 2017 at 10:13 PM, Konstantin Knizhnik
> >  wrote:
> > > Concerning broken partition_join test: it is "expected" failure: my patch
> > > removes from the plans redundant checks.
> > > So the only required action is to update expected file with results.
> > > Attached please find updated patch.
> > The last patch version has conflicts in regression tests and did not
> > get any reviews. Please provide a rebased version. I am moving the
> > patch to next CF with waiting on author as status. Thanks!
> 
> Rebased patch is attached.

I don't think this is a rebase on the previously posted patch ... it's
about 10x as big and appears to be a thorough rewrite of the entire
optimizer.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

В списке pgsql-hackers по дате отправления
От: Chapman Flack
Дата:
Сообщение: Signals in a BGW
От: Marco Pfatschbacher
Дата:
FAQ