Neil Conway <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings