| From: | Alexey Bashtanov <bashtanov(at)imap(dot)cc> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Cc: | Melanie Plageman <melanieplageman(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Improve planner cost estimations for alternative subplans |
| Date: | 2020-07-24 14:57:39 |
| Message-ID: | 64896725-33ed-4084-1e7c-402f22bc3525@imap.cc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Tom,
sorry for the delay,
> I experimented with adding a number-of-evaluations parameter to
> cost_qual_eval, and found that the majority of call sites do have
> something realistic they can pass. The attached very-much-WIP
> patch shows my results so far. There's a lot of loose ends:
I like the idea, so if we alternative subplans remain there
I think we should implement it.
Best, Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2020-07-24 15:06:58 | Re: HOT vs freezing issue causing "cannot freeze committed xmax" |
| Previous Message | Alexey Bashtanov | 2020-07-24 14:55:57 | Re: Improve planner cost estimations for alternative subplans |