Re: [GENERAL] Optimizing Queries Joining Several Views

2012-01-26 Thread Tom Lane
Jason Long writes: > In order to do some complex calculations I have joined several views. > Each view could join quite a few tables. > The user is allowed to filter the results with several multi-select > input fields and this is used in the query as where a.id in > (:listOfIds). > This works f

[GENERAL] Optimizing Queries Joining Several Views

2012-01-26 Thread Jason Long
In order to do some complex calculations I have joined several views. Each view could join quite a few tables. The user is allowed to filter the results with several multi-select input fields and this is used in the query as where a.id in (:listOfIds). This works fine if the user does not filter