pgsql: Fix some typos

2024-01-21 Thread Michael Paquier
Fix some typos Author: Yongtao Huang Discussion: https://postgr.es/m/caoe1go1f99o5jsphtxddc5bxm7azetu8q3axlh4aavgku1a...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b199eb89c67d737ced55721590f7fc8ff585e837 Modified Files --

pgsql: Add test module injection_points

2024-01-21 Thread Michael Paquier
Add test module injection_points This provides basic coverage for injection points within a single process, while providing some callbacks that can be used for other tests. There are plans to extend this module later with more advanced capabilities for tests. Author: Michael Paquier, with

pgsql: Add backend support for injection points

2024-01-21 Thread Michael Paquier
Add backend support for injection points Injection points are a new facility that makes possible for developers to run custom code in pre-defined code paths. Its goal is to provide ways to design and run advanced tests, for cases like: - Race conditions, where processes need to do actions in a

Re: pgsql: Explore alternative orderings of group-by pathkeys during optimi

2024-01-21 Thread Alexander Korotkov
On Sun, Jan 21, 2024 at 11:09 PM Tom Lane wrote: > Alexander Korotkov writes: > > Explore alternative orderings of group-by pathkeys during optimization. > > Buildfarm's not terribly happy. Looks like you incautiously used > a table name "t1" that's already in use in a concurrent script. Thank

pgsql: Fix table name collision in tests in 0452b461bc

2024-01-21 Thread Alexander Korotkov
Fix table name collision in tests in 0452b461bc Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c03d91d9be378975bcdbfa3e5d40e17288e6f13f Modified Files -- src/test/regress/expected/aggregates.out | 16 src/test/regress/sql/aggregates.sql

Re: pgsql: Explore alternative orderings of group-by pathkeys during optimi

2024-01-21 Thread Tom Lane
Alexander Korotkov writes: > Explore alternative orderings of group-by pathkeys during optimization. Buildfarm's not terribly happy. Looks like you incautiously used a table name "t1" that's already in use in a concurrent script. regards, tom lane

pgsql: Explore alternative orderings of group-by pathkeys during optimi

2024-01-21 Thread Alexander Korotkov
Explore alternative orderings of group-by pathkeys during optimization. When evaluating a query with a multi-column GROUP BY clause, we can minimize sort operations or avoid them if we synchronize the order of GROUP BY clauses with the ORDER BY sort clause or sort order, which comes from the

pgsql: Generalize the common code of adding sort before processing of g

2024-01-21 Thread Alexander Korotkov
Generalize the common code of adding sort before processing of grouping Extract the repetitive code pattern into a new function make_ordered_path(). Discussion: https://postgr.es/m/CAPpHfdtzaVa7S4onKy3YvttF2rrH5hQNHx9HtcSTLbpjx%2BMJ%2Bw%40mail.gmail.com Author: Andrei Lepikhov Branch --