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

Re: View vs Stored Proc Performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan Voras <ivoras(at)freebsd(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: View vs Stored Proc Performance
Date: 2009-09-15 15:26:13
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
Ivan Voras <ivoras(at)freebsd(dot)org> writes:
> Are functions in language 'sql' handled differently than those of 
> language 'plpgsql'?


> I think they're not so in any case a function will behave as a black box 
> with regards to the planner and optimizer (and views are always 
> 'transparent').


			regards, tom lane

In response to


pgsql-performance by date

Next:From: Robert HaasDate: 2009-09-15 15:44:59
Subject: Re: disable heavily updated (but small) table auto-vecuuming
Previous:From: Ivan VorasDate: 2009-09-15 15:14:06
Subject: Re: View vs Stored Proc Performance

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