Re: pl/pgsql Plan Invalidation and search_path - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: pl/pgsql Plan Invalidation and search_path
Date
Msg-id b42b73150803251907iaa1169bndd41b966ff7b8ada@mail.gmail.com
Whole thread Raw
In response to Re: pl/pgsql Plan Invalidation and search_path  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pl/pgsql Plan Invalidation and search_path  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Mon, Mar 24, 2008 at 9:48 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
>  Add to pl/pgsql TODO:
>
>         o Consider invalidating the cache or keeping seperate cached
>           copies when search_path changes
>
>           http://archives.postgresql.org/pgsql-hackers/2008-01/msg01009.php

IMO, Tom's idea, namely to keep separate cache plans for various
search_path settings, is a much stronger proposal and should probably
get the 'todo'.

merlin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Script binaries renaming
Next
From: Bruce Momjian
Date:
Subject: Re: pl/pgsql Plan Invalidation and search_path