Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance. - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
Date
Msg-id 16847.1486485453@sss.pgh.pa.us
Whole thread Raw
In response to [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.  (Herwig Goemans <herwig.goemans@gmail.com>)
Responses Re: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting inbad performance.
List pgsql-sql
Tree view 
Herwig Goemans <herwig.goemans@gmail.com> writes:
> I am wondering why a certain query is NOT pushing the where clause to the
> view. See query and explain plan:

There's no provision for transitively applying IN clauses to other
variables.  I'm not entirely sure whether it would be a good idea,
but in any case, it's not there and not planned.
        regards, tom lane

pgsql-sql by date:

Previous
From: Herwig Goemans
Date:
Subject: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
Next
From: Herwig Goemans
Date:
Subject: Re: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting inbad performance.