| From: | Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Don't search for volatile expr in find_em_expr_usable_for_sortin |
| Date: | 2020-12-21 19:47:46 |
| Message-ID: | E1krR9m-0006Ho-7x@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Don't search for volatile expr in find_em_expr_usable_for_sorting_rel
While prepare_sort_from_pathkeys has to be concerned about matching up
a volatile expression to the proper tlist entry, we don't need to do
that in find_em_expr_usable_for_sorting_rel becausee such a sort will
have to be postponed anyway.
Author: James Coleman
Reviewed-by: Tomas Vondra
Backpatch-through: 13
Discussion: https://postgr.es/m/CAAaqYe8cK3g5CfLC4w7bs%3DhC0mSksZC%3DH5M8LSchj5e5OxpTAg%40mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/9aff4dc01fbb9e126efafd839ae8541362328f1a
Modified Files
--------------
src/backend/optimizer/path/equivclass.c | 28 +++++-----------------------
1 file changed, 5 insertions(+), 23 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2020-12-21 19:48:05 | pgsql: Don't search for volatile expr in find_em_expr_usable_for_sortin |
| Previous Message | Tomas Vondra | 2020-12-21 18:36:41 | pgsql: Disallow SRFs when considering sorts below Gather Merge |