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
Ответ на
Re: why partition pruning doesn't work? (David Rowley)
Список
Дерево обсуждения
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
Дата: