emote side).
It should be possible at least for simple aggregation (without distinct etc)
Thanks!
Stepan Yankevych
Office: +380 322 424 642xx58840 Cell:
+380 96 915 9551 Email:
stepan_yankev...@epam.com<mailto:stepan_yankev...@epam.com>
Lviv, Ukraine epam.com<http://www.epam.com
1021
Stepan Yankevych
From: Andrei Lepikhov
Sent: Sunday, November 3, 2024 4:42 AM
To: Vijaykumar Jain ; Stepan Yankevych
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Postgresql 14/15/16/17 partition pruning on dependent table during
join
On 3
andomly adds up to 10
days to the original date for additional records
END AS exec_date_id,
clock_timestamp() - (RANDOM() * INTERVAL '10 days') AS exec_time, -- Random
timestamp within the last 10 days
(RANDOM() * 1000)::int AS qty, -- Random quantity
(RANDOM() * 100)::numeric(10,2) AS price -- Random price
FROM
exec_ids;
Stepan Yankevych
