Postgres Pro
Downloads
Home   >   mailing lists

Re: View's plan not taking advantage of WHERE? - Mailing list pgsql-general

From Mike Summers
Subject Re: View's plan not taking advantage of WHERE?
Date
Msg-id CAJGeMG8_-TE7wt1ff9eiUvcsaRG2aF2-wvvjkkvwxzCP_KZE9A@mail.gmail.com
Whole thread Raw
In response to View's plan not taking advantage of WHERE?  (Mike Summers <msummers57@gmail.com>)
Responses Re: View's plan not taking advantage of WHERE?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view
It appears that the culprit is a cached query plan, the tables in the UNION have changed and no long match however the View does not throw a "each UNION query must have the same number of columns" error.

Is there a way to force the View's query plan to be updated on each access?

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: How to modify dump files created by pg_dump
Next
From: Scott Marlowe
Date:
Subject: Re: View's plan not taking advantage of WHERE?