pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql: Teach planner how to estimate rows for timestamp generate_series
2+ messages / 2 participants
[nested] [flat]
Commits from this thread:
2024-07-09 c048cd992c Avoid JIT-related test instability in EXPLAIN ANALYZE
* pgsql: Teach planner how to estimate rows for timestamp generate_series
@ 2024-07-08 21:55 David Rowley <drowley@postgresql.org>
2024-07-09 00:15 ` Re: pgsql: Teach planner how to estimate rows for timestamp generate_series David Rowley <dgrowleyml@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: David Rowley @ 2024-07-08 21:55 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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
parameter values can be estimated during planning.
Author: David Rowley
Reviewed-by: jian he <jian.universality@gmail.com>
Discussion: https://postgr.es/m/CAApHDvrBE%3D%2BASo_sGYmQJ3GvO8GPvX5yxXhRS%3Dt_ybd4odFkhQ%40mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/036bdcec9f9998a6e50711fadce69e482ff18f55
Modified Files
--------------
src/backend/utils/adt/timestamp.c | 88 +++++++++++++++++++++
src/include/catalog/pg_proc.dat | 12 ++-
src/test/regress/expected/misc_functions.out | 110 +++++++++++++++++++++++++++
src/test/regress/sql/misc_functions.sql | 84 ++++++++++++++++++++
4 files changed, 291 insertions(+), 3 deletions(-)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgsql: Teach planner how to estimate rows for timestamp generate_series
2024-07-08 21:55 pgsql: Teach planner how to estimate rows for timestamp generate_series David Rowley <drowley@postgresql.org>
@ 2024-07-09 00:15 ` David Rowley <dgrowleyml@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David Rowley @ 2024-07-09 00:15 UTC (permalink / raw)
To: David Rowley <drowley@postgresql.org>; +Cc: pgsql-committers@lists.postgresql.org
On Tue, 9 Jul 2024 at 09:55, David Rowley <drowley@postgresql.org> 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-bin/show_history.pl?nm=bushmaster&br=HEAD
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-07-09 00:15 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-08 21:55 pgsql: Teach planner how to estimate rows for timestamp generate_series David Rowley <drowley@postgresql.org>
2024-07-09 00:15 ` David Rowley <dgrowleyml@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox