Default setting for enable_hashagg_disk
От
Jeff Davis
Тема
Default setting for enable_hashagg_disk
Дата
Msg-id
9d9d1e1252a52ea1bad84ea40dbebfd54e672a0f.camel@j-davis.com
Список
Дерево обсуждения
Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Justin Pryzby <pryzby@telsasoft.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Justin Pryzby <pryzby@telsasoft.com>
Re: Default setting for enable_hashagg_disk Greg Stark <stark@mit.edu>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Melanie Plageman <melanieplageman@gmail.com>
Re: Default setting for enable_hashagg_disk Justin Pryzby <pryzby@telsasoft.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Justin Pryzby <pryzby@telsasoft.com>
Re: Default setting for enable_hashagg_disk Justin Pryzby <pryzby@telsasoft.com>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Justin Pryzby <pryzby@telsasoft.com>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk David Rowley <dgrowleyml@gmail.com>
Re: Default setting for enable_hashagg_disk Justin Pryzby <pryzby@telsasoft.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Justin Pryzby <pryzby@telsasoft.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Andres Freund <andres@anarazel.de>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk David Rowley <dgrowleyml@gmail.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Andres Freund <andres@anarazel.de>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Andres Freund <andres@anarazel.de>
Re: Default setting for enable_hashagg_disk Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Andres Freund <andres@anarazel.de>
Re: Default setting for enable_hashagg_disk Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk David Rowley <dgrowleyml@gmail.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Amit Kapila <amit.kapila16@gmail.com>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Amit Kapila <amit.kapila16@gmail.com>
Re: Default setting for enable_hashagg_disk David Rowley <dgrowleyml@gmail.com>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk David Rowley <dgrowleyml@gmail.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk David Rowley <dgrowleyml@gmail.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Thomas Munro <thomas.munro@gmail.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk David Rowley <dgrowleyml@gmail.com>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Stephen Frost <sfrost@snowman.net>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Tom Lane <tgl@sss.pgh.pa.us>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk "David G. Johnston" <david.g.johnston@gmail.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Andres Freund <andres@anarazel.de>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Andres Freund <andres@anarazel.de>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Andres Freund <andres@anarazel.de>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Robert Haas <robertmhaas@gmail.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Andres Freund <andres@anarazel.de>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Bruce Momjian <bruce@momjian.us>
Re: Default setting for enable_hashagg_disk Amit Kapila <amit.kapila16@gmail.com>
Re: Default setting for enable_hashagg_disk Peter Geoghegan <pg@bowt.ie>
Re: Default setting for enable_hashagg_disk Melanie Plageman <melanieplageman@gmail.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
Re: Default setting for enable_hashagg_disk Melanie Plageman <melanieplageman@gmail.com>
Re: Default setting for enable_hashagg_disk Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk David Rowley <dgrowleyml@gmail.com>
Re: Default setting for enable_hashagg_disk Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Default setting for enable_hashagg_disk Jeff Davis <pgsql@j-davis.com>
This is just a placeholder thread for an open item that I'm adding to the Open Items list. We can make a decision later. Now that we have Disk-based Hash Aggregation, there are a lot more situations where the planner can choose HashAgg. The enable_hashagg_disk GUC, if set to true, chooses HashAgg based on costing. If false, it only generates a HashAgg path if it thinks it will fit in work_mem, similar to the old behavior (though it wlil now spill to disk if the planner was wrong about it fitting in work_mem). The current default is true. I expect this to be a win in a lot of cases, obviously. But as with any planner change, it will be wrong sometimes. We may want to be conservative and set the default to false depending on the experience during beta. I'm inclined to leave it as true for now though, because that will give us better information upon which to base any decision. Regards, Jeff Davis
В списке pgsql-hackers по дате отправления
От: Ashwin Agrawal
Дата: