[pgpool-hackers: 778] Idea to imporve catalog look up cache

[Tatsuo Ishii]

Hi pgpool-II hackers,

pgpool-II needs to look up PostgreSQL's system catalog to get info on
tables. The results are cached in each child process's own memory
space and persists until the process exits (except "session local"
cache which is for info on temporary table).

If we could place the cache in shared memory instead of process memory
space, the frequency to issue such that query will be dramatically
down and should improve performance especially there are many
concurrent sessions.

Thoughts, comments?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp