Re: Perfomance of views - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Perfomance of views
Date
Msg-id 43609EF4.8060907@archonet.com
Whole thread Raw
In response to Perfomance of views  (Svenne Krap <svenne@krap.dk>)
Responses Re: Perfomance of views
List pgsql-performance
Svenne Krap wrote:
> Hi there.
>
> I am currently building a system, where it would be nice to use multiple
> levels of views upon each other (it is a staticstics system, where
> traceability is important).
>
> Is there any significant performance reduction in say 10 levels of views
> instead of one giant, nested sql-statement ? I especially think exection
> planner-wise.

The planner tries to push conditions "inside" views where it can. It's
not perfect though, and if you're writing a big query by hand you might
be able to do better than it.

In short, I'd test if you can.
--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: performance on query
Next
From: Svenne Krap
Date:
Subject: Re: Perfomance of views