Re: why partition pruning doesn't work?

Поиск
Список
Период
Сортировка
Искать
От
Amit Langote
Тема
Re: why partition pruning doesn't work?
Дата
Msg-id
e6e751ea-0db4-0e7b-9513-97460edb60b3@lab.ntt.co.jp
Ответ на
Список
Дерево обсуждения
why partition pruning doesn't work? Pavel Stehule <pavel.stehule@gmail.com>
Re: why partition pruning doesn't work? Dmitry Dolgov <9erthalion6@gmail.com>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Pavel Stehule <pavel.stehule@gmail.com>
Re: why partition pruning doesn't work? Jeff Janes <jeff.janes@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Dmitry Dolgov <9erthalion6@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Dmitry Dolgov <9erthalion6@gmail.com>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Dmitry Dolgov <9erthalion6@gmail.com>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Pavel Stehule <pavel.stehule@gmail.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: why partition pruning doesn't work? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
On 2018/06/06 14:10, David Rowley wrote:
> I then decided that
> I didn't like the way we need to check which params are in the Expr
> each time we call partkey_datum_from_expr. It seems better to prepare
> this in advance when building the pruning steps. I started work on
> that, but soon realised that I'd need to pass a List of Bitmapsets to
> the executor. This is a problem as Bitmapset is not a Node type and
> cannot be copied with COPY_NODE_FIELD(). Probably this could be
> refactored to instead of passing 3 Lists in the PartitionPruneStepOp
> we could invent a new node type that just has 3 fields and store a
> single List.

I wonder why we need to create those Bitmapsets in the planner?  Why not
in ExecSetupPartitionPruneState()?  For example, like how
context->exprstates is initialized.

Thanks,
Amit


В списке pgsql-hackers по дате отправления
От: Ashutosh Bapat
Дата:
От: Rajkumar Raghuwanshi
Дата:
FAQ