Re: Do Views offer any performance advantage?

From: Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Do Views offer any performance advantage?
Date: 2003-04-16 08:45:20
Message-ID: 3E9D1820.6000100@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane wrote:

>This is not the view's fault though --- the same would have happened
>if you'd written explicitly
>
> FROM A JOIN B JOIN (D JOIN E)
>
That's right, I just wanted to warn about accessive use of joins with
views. I noticed this in an application, where quite big views where
joined for convenience, and the result wasn't satisfying.

>
>7.4 will be less rigid about this (with or without a view ...)
>
Good!
Regards,
Andreas

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-04-16 15:48:36 Re: for help!
Previous Message Jonathan Moore 2003-04-16 06:58:28 dum query plan