[pgpool-hackers: 3678] Re: in-memory query for tables with rewrite rules

[Tatsuo Ishii]

> Hi pgpool hackers,
> 
> 
> I have a question about in-memory query.
> 
> 
> The document says 'when a table is updated, Pgpool-II automatically deletes all the caches related to the table'
> 
> 
> when I update some tables with rewrite rules,
> The sql may be rewritten to update different tables.
> 
> 
> Can pgpool deletes the correct caches ?

No. To delete the caches Pgpool-II needs to know the updated table
name from the SQL sent from client. In the rewrite rule case, names of
deleted tables are not known to Pgpool-II and cache for the table will
not be deleted.

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