Re: pgsql: Teach planner how to estimate rows for timestamp generate_series

2024-07-08 Thread David Rowley
On Tue, 9 Jul 2024 at 09:55, David Rowley wrote: > src/test/regress/expected/misc_functions.out | 110 +++ > src/test/regress/sql/misc_functions.sql | 84 I'll look at fixing bushmaster [1] shortly. David [1] https://buildfarm.postgresql.org/cgi

pgsql: Teach planner how to estimate rows for timestamp generate_series

2024-07-08 Thread David Rowley
Teach planner how to estimate rows for timestamp generate_series This provides the planner with row estimates for generate_series(TIMESTAMP, TIMESTAMP, INTERVAL), generate_series(TIMESTAMPTZ, TIMESTAMPTZ, INTERVAL) and generate_series(TIMESTAMPTZ, TIMESTAMPTZ, INTERVAL, TEXT) when the input parame