Re: [HACKERS] Any advice about function caching?

2005-11-08 Thread Mark Cave-Ayland
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 07 November 2005 23:06 > To: Mark Cave-Ayland (External) > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Any advice about function caching? (cut) > If you want per-query sta

Re: [HACKERS] Any advice about function caching?

2005-11-07 Thread Tom Lane
"Mark Cave-Ayland" <[EMAIL PROTECTED]> writes: > My current code works by using MemoryContextCreate() to create a child > context to MessageContext and using the Init()/Delete() functions to > initialise and destroy a cache in the local backend. However, this doesn't > really work particularly well

[HACKERS] Any advice about function caching?

2005-11-07 Thread Mark Cave-Ayland
Hi everyone, I'm currently in the middle of trying to implement a cache for a PostGIS server-side function that uses an external library with an expensive startup cost, and was hoping to find some advice on the best way to implement it. The function currently takes 2 parameters - a customised C g