Postgres Pro
Downloads
Home   >   mailing lists

Re: Selection not "pushed down into" CTE - Mailing list pgsql-performance

From Clemens Eisserer
Subject Re: Selection not "pushed down into" CTE
Date
Msg-id CAFvQSYSYMDjSwpD748LYsaeK_xXCnYJ-gDbTY9nuh2+5kB5i-w@mail.gmail.com
Whole thread Raw
In response to Re: Selection not "pushed down into" CTE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
Hi Tom,

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

Best regards, Clemens



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Selection not "pushed down into" CTE
Next
From: Jerry Brenner
Date:
Subject: Why is a sort required for this query? (IS NULL predicate on leading key column)