Re: "SELECT ... FROM DUAL" is not quite as silly as it appears
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Mark Dilger <hornschnorter@gmail.com>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2019-01-15T00:17:24Z
Lists: pgsql-hackers
David Rowley <david.rowley@2ndquadrant.com> writes: > 1. I don't think having a table named "dual" makes a whole lot of > sense for a table with a single row. Well, I borrowed Oracle terminology there ;-) > (Uppercasing these additions would also make them look less of an afterthought.) Don't really care, can do. > I also did a quick benchmark of v6 and found the slowdown to be > smaller after the change made in build_simple_rel() Thanks for confirming. I was not very sure that was worth the extra few bytes of code space, but if you see a difference too, then it's probably worthwhile. regards, tom lane
Commits
-
In the planner, replace an empty FROM clause with a dummy RTE.
- 4be058fe9ec5 12.0 landed
-
Fix jit compilation bug on wide tables.
- b238527664ec 12.0 cited