Re: [HACKERS] Cache query (PREPARE/EXECUTE)

Karel Zak <zakkr@zf.jcu.cz>

From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: Don Baccus <dhogaza@pacifier.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 2000-02-22T20:18:47Z
Lists: pgsql-hackers
On Tue, 22 Feb 2000, Don Baccus wrote:

> At 06:30 PM 2/22/00 +0100, Karel Zak - Zakkr wrote:
> 
> > Yes, I agree (TopMemoryContext was simpl for first hacking). 
> >But I not sure how create new (across transaction persistent?) 
> >MemoryContext. It needs new portal? (Sorry I not thoroughly explore
> >PG's memory management.)  
> 
> Jan is caching the plans needed for referential integrity checking
> and referential actions - look at ri_triggers.c in src/backend/utils/adt.
> ri_InitHashTables initializes the RI cache.

 My cache table routines for PREPARE = Jan's RI routines :-) 
(I copy and a little modify Jan's code (*Thanks* Jan for good inspiration..).

But if I good look at Jan use SPI context for this, not any specific
context. 

						Karel