Re: invalidating cached plans - Mailing list pgsql-hackers

From Tom Lane
Subject Re: invalidating cached plans
Date
Msg-id 6275.1110786816@sss.pgh.pa.us
Whole thread Raw
In response to Re: invalidating cached plans  (Neil Conway <neilc@samurai.com>)
Responses Re: invalidating cached plans  (Michael Adler <adler@pobox.com>)
Re: invalidating cached plans  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> Tom Lane wrote:
>> I would like to see this folded together with creation of a centralized
>> plan caching module.

> Interesting. Can you elaborate on how you'd envision call sites making 
> use of this module?

I hadn't really gotten as far as working out a reasonable API for the
module.  The $64 question seems to be what is the input: a textual query
string, a raw parse analysis tree, or what?  And what sort of key does
the caller want to use to re-find a previously cached plan?

Probably the first thing to do is look around at the plausible users of
this thing and see what they'd find most convenient.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: int64/double for time/timestamp
Next
From: Tom Lane
Date:
Subject: Re: options in conninfo