Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group