On Wed, Oct 23, 2002 at 11:02:14AM -0400, Tom Lane wrote: > =?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes: > > I wonder if there is a way to store a parsed/rewritten/planned query in > > a table so that it can be loaded again. > > The original version of the PREPARE patch used a shared-across-backends > cache for PREPAREd statements. We rejected that for a number of > reasons, one being the increased difficulty of keeping such a cache up > to date. I think actually storing the plans on disk would have all the > same problems, but worse.
Right. There's solution: persisten backend (for example like classic apache). This solve problem with lifetime of all persistent caches. It's already in TODO. Karel -- Karel Zak <[EMAIL PROTECTED]> http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])