On Sun, Nov 24, 2013 at 4:21 PM, Simon Riggs <si...@2ndquadrant.com> wrote:
> Why do you need to do this dance with fn_extra? > > It's possible to allocate a hash table in a Transaction-lifetime > memory context on first call into a function then cache things there. > fn_extra gives a handle per function call site. It sounds to me like the complexity is coming not from having many Postgres functions but from having lots of infrastructure backing up those functions. So if many of their Postgres functions call a C function to do various things and the C function wants to cache something somewhere related to the object they've been passed then the natural thing to do is have the Postgres function pass fn_extra down to the C function but if they have many such C functions it gets a bit tricky. But you could declare fn_extra to be a hash table yourself since it's your Postgres function that gets to decide how fn_extra is going to be used. You could then pass that hash table down to the various C functions to cache state. However that might still be a bit odd. If you call the same C function twice from the same Postgres function it'll get the same hash table for both calls. fn_extra is per Postgres function call site. -- greg