Re: plpgsql function confusing behaviour - Mailing list pgsql-general

From Shianmiin
Subject Re: plpgsql function confusing behaviour
Date
Msg-id 1310490650891-4579619.post@n5.nabble.com
Whole thread Raw
In response to Re: plpgsql function confusing behaviour  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: plpgsql function confusing behaviour
List pgsql-general
Merlin Moncure-2 wrote:
>
> One proposed solution is to cache plpgsql plans around the search path.
>

I like the proposed solution, since search_path plays a part when generating
plpgsql plan, it make sense to be part of the cache.


Merlin Moncure-2 wrote:
>
> *) use sql functions for portions that float across schemas
>

Just to clarify, does this mean the sql functions doesn't cache plans like
plpgsql functions do?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/plpgsql-function-confusing-behaviour-tp4576354p4579619.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: ts_rank seems very slow (140 ranked documents / second on my machine)
Next
From: Giuseppe Sacco
Date:
Subject: About permissions on large objects