| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Atri Sharma <atri(dot)jiit(at)gmail(dot)com> |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Mart Kelder <mart(at)kelder31(dot)nl>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: Removing INNER JOINs |
| Date: | 2014-12-03 18:11:44 |
| Message-ID: | 20586.1417630304@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Atri Sharma <atri(dot)jiit(at)gmail(dot)com> writes:
> Does it also make sense to recalculate the costs from scratch for the
> replan? It might be, I am just asking.
The join costs would be recalculated from scratch, yes. The
single-relation Paths would already exist and their costs would not
change. Again, if you've not studied how GEQO works, you probably
should go do that before thinking more about how this would work.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atri Sharma | 2014-12-03 18:12:53 | Re: Removing INNER JOINs |
| Previous Message | Alvaro Herrera | 2014-12-03 18:11:32 | Re: tracking commit timestamps |