Re: PATCH: generate fractional cheapest paths in generate_orderedappend_path
Tomas Vondra <tomas.vondra@enterprisedb.com>
From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: Zhihong Yu <zyu@yugabyte.com>
Cc: Arne Roland <A.Roland@index.de>,
pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2021-06-03T20:57:38Z
Lists: pgsql-hackers
On 6/3/21 10:52 PM, Zhihong Yu wrote: > ... > > Sent a bit too soon. > > The above function still exists. > But startup_new_fractional was nowhere to be found. Actually, there are two comments /* XXX maybe we should have startup_new_fractional? */ in the patch I posted - I completely forgot about that. But I think that's a typo, I think - it should be /* XXX maybe we should have startup_neq_fractional? */ and the new flag would work similarly to startup_neq_total, i.e. it's pointless to add paths where startup == fractional cost. At least I think that was the idea when I wrote the patch, it way too long ago. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Commits
-
Consider fractional paths in generate_orderedappend_paths
- 6b94e7a6da2f 15.0 landed
-
Support MergeAppend plans, to allow sorted output from append relations.
- 11cad29c9152 9.1.0 cited