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