Re: PATCH: generate fractional cheapest paths in generate_orderedappend_path

Arne Roland <a.roland@index.de>

From: Arne Roland <A.Roland@index.de>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2021-06-03T17:17:55Z
Lists: pgsql-hackers

Attachments

Hi,


I haven't tested the parallel case, but I think we should sort out (3) get_cheapest_fractional_path_for_pathkeys as mentioned above.


I am lost about the comment regarding startup_new_fractional. Could you elaborate what you mean by that?


Apart from that, I'd argue for a small test case. I attached a slimmed down case of what we were trying to fix. It might be worth to integrate that with an existing test, since more than a third of the time seems to be consumed by the creation and attachment of partitions.


Regards
Arne

Commits

  1. Consider fractional paths in generate_orderedappend_paths

  2. Support MergeAppend plans, to allow sorted output from append relations.