Re: why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Herwig Goemans <herwig(dot)goemans(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
Date: 2017-02-07 16:37:33
Message-ID: 16847.1486485453@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Herwig Goemans <herwig(dot)goemans(at)gmail(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Herwig Goemans 2017-02-08 10:20:14 Re: why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
Previous Message Herwig Goemans 2017-02-07 10:53:58 why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.