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: 12712.1253028373@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Ivan Voras <ivoras(at)freebsd(dot)org> writes:
> Are functions in language 'sql' handled differently than those of 
> language 'plpgsql'?

Yes.

> 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').

No.

			regards, tom lane

In response to

Responses

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-2014 The PostgreSQL Global Development Group