Re: Poor performance using CTE
От
Craig Ringer
Тема
Re: Poor performance using CTE
Дата
Msg-id
50AC1472.3050607@2ndQuadrant.com
Ответ на
Re: Poor performance using CTE (Claudio Freire)
Список
Дерево обсуждения
Poor performance using CTE David Greco <David_Greco@harte-hanks.com>
Re: Poor performance using CTE Merlin Moncure <mmoncure@gmail.com>
Re: Poor performance using CTE Claudio Freire <klaussfreire@gmail.com>
Re: Poor performance using CTE Merlin Moncure <mmoncure@gmail.com>
Re: Poor performance using CTE Claudio Freire <klaussfreire@gmail.com>
Re: Poor performance using CTE Craig Ringer <craig@2ndQuadrant.com>
Re: Poor performance using CTE Tom Lane <tgl@sss.pgh.pa.us>
Re: Poor performance using CTE Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Poor performance using CTE Andrew Dunstan <andrew@dunslane.net>
Re: Poor performance using CTE Tom Lane <tgl@sss.pgh.pa.us>
Re: Poor performance using CTE Andrew Dunstan <andrew@dunslane.net>
Re: Poor performance using CTE Andres Freund <andres@anarazel.de>
Re: Poor performance using CTE Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Poor performance using CTE Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Poor performance using CTE Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Poor performance using CTE Andrew Dunstan <andrew@dunslane.net>
Re: Poor performance using CTE Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Poor performance using CTE Craig Ringer <craig@2ndQuadrant.com>
Re: Poor performance using CTE Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Poor performance using CTE Craig Ringer <craig@2ndQuadrant.com>
Re: Poor performance using CTE Jeremy Harris <jgh@wizmail.org>
Re: Poor performance using CTE Jon Nelson <jnelson+pgsql@jamponi.net>
Re: Poor performance using CTE Claudio Freire <klaussfreire@gmail.com>
Re: Poor performance using CTE Andres Freund <andres@2ndquadrant.com>
Re: Poor performance using CTE Claudio Freire <klaussfreire@gmail.com>
Re: Poor performance using CTE Andres Freund <andres@2ndquadrant.com>
Re: Poor performance using CTE Andrew Dunstan <andrew@dunslane.net>
Re: Poor performance using CTE Claudio Freire <klaussfreire@gmail.com>
Re: Poor performance using CTE Tom Lane <tgl@sss.pgh.pa.us>
Re: Poor performance using CTE Peter Geoghegan <peter@2ndquadrant.com>
Re: Poor performance using CTE Peter Geoghegan <peter@2ndquadrant.com>
Re: Poor performance using CTE Claudio Freire <klaussfreire@gmail.com>
On 11/21/2012 12:06 AM, Claudio Freire wrote: > I meant for postgres to do automatically. Rewriting as a join wouldn't > work as an optimization fence the way we're used to, but pushing > constraints upwards can only help (especially if highly selective). Because people are now used to using CTEs as query hints, it'd probably cause performance regressions in working queries. Perhaps more importantly, Pg would have to prove that doing so didn't change queries that invoked functions with side-effects to avoid changing the results of currently valid queries. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-performance по дате отправления
