Postgres Pro
Downloads
Home   >   mailing lists

View optimization - Mailing list pgsql-general

From Richard Ollier
Subject View optimization
Date
Msg-id 45876B4A.5040901@tequila.co.jp
Whole thread Raw
Responses Re: View optimization  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
Hello,

I was wondering it there was a way to optimize a view.
If my view contains 20 LEFT joins, my guessing is that each time I will
make a select on it, the view will be completely recalculated. Is there
a way to have it up and running all the time like a table would be ?

Any advice here is more than welcome !

Thanks
Richard

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Changes in 8.2's PHP behaviour?
Next
From: Richard Broersma Jr
Date:
Subject: Re: feature request for Postgresql Rule system.