Re: Selection not "pushed down into" CTE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Selection not "pushed down into" CTE
From: Clemens Eisserer <linuxhippy@xxxxxxxxx>
Date: Thu, 11 Jan 2024 18:48:35 +0100
In-reply-to: <1606644.1704646551@sss.pgh.pa.us>
References: <CAFvQSYSWH2mJbnh0A16TXppm71PsYF1E9pnTw7Vi751hgpKufg@mail.gmail.com> <1606644.1704646551@sss.pgh.pa.us>

Hi Tom,

Thanks for the detailed explanation what is preventing the
optimization and the view behind the scenes.

Best regards, Clemens

References:
- Selection not "pushed down into" CTE
  - From: Clemens Eisserer
- Re: Selection not "pushed down into" CTE
  - From: Tom Lane

Prev by Date: Re: Slow GroupAggregate and Sort
Next by Date: Why is a sort required for this query? (IS NULL predicate on leading key column)
Previous by thread: Re: Selection not "pushed down into" CTE
Next by thread: Why is a sort required for this query? (IS NULL predicate on leading key column)
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux