overhead of plpgsql functions over simple select

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: overhead of plpgsql functions over simple select
Date: 2008-10-23 16:05:18
Message-ID: 20081023180518.587c1bfe@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd like to encapsulate something that now is just a simple select
in a plpgsql function now just to keep an interface consistent but
even for well... encapsulating the sql.

Right now a simple select statement will suffice.

What kind of overhead a plpgsql that just return a select incur
compared to a simple select?

I'm not that worried of old query plans.

thx

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-10-23 16:34:18 Re: Postgres optimizer choosing wrong index
Previous Message Jack Orenstein 2008-10-23 15:40:06 Postgres optimizer choosing wrong index