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

Don Baccus <dhogaza@pacifier.com>

From: Don Baccus <dhogaza@pacifier.com>
To: Karel Zak - Zakkr <zakkr@zf.jcu.cz>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 2000-02-22T18:56:07Z
Lists: pgsql-hackers
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.

(I *assume* Jan, with his great experience, is doing it right, I'm
in no position to judge!)



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.