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
- merge-fraction-cheapest_example.sql (application/sql)
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
-
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