overhead of plpgsql functions over simple select - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject overhead of plpgsql functions over simple select
Date
Msg-id 20081023180518.587c1bfe@dawn.webthatworks.it
Whole thread Raw
Responses Re: overhead of plpgsql functions over simple select  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List 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


pgsql-general by date:

Previous
From: Jack Orenstein
Date:
Subject: Postgres optimizer choosing wrong index
Next
From: Tom Lane
Date:
Subject: Re: Postgres optimizer choosing wrong index