Re: Slow GroupAggregate and Sort

Hello, my answers in blue again El Wed, 03 Jan 2024 21:43:15 -0500, Jeff Janes escribió On Mon, Jan 1, 2024 at 9:57 AM Darwin Correa wrote: Hello, Happy New Year! I add my responses in blue. El Thu, 28 Dec 2023 13:06:18 -0500, Jeff Ja

Re: Selection not "pushed down into" CTE

Clemens Eisserer writes: > running postgresql 15.5 I was recently surpised postgresql didn't > perform an optimization which I thought would be easy to apply. It is not. > running the following query results in a full sort (caused by lead > over order by) as the ts > '2024-01-04' selection doesn