View optimization

From: Richard Ollier <r(dot)ollier(at)tequila(dot)co(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: View optimization
Date: 2006-12-19 04:32:10
Message-ID: 45876B4A.5040901@tequila.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-12-19 05:08:23 Re: Changes in 8.2's PHP behaviour?
Previous Message Reece Hart 2006-12-19 04:24:08 Re: Anyone? Best way to authenticate postgres against