[pgpool-hackers: 4505] Re: Proposal to backport notice_per_node_statement
Tatsuo Ishii
ishii at postgresql.org
Wed Aug 14 15:37:28 JST 2024
> The feature is pretty useful for testing because it allows to take
> psql output logs for queries pgpool sends to each backend node, then
> compare the logs with expected output so that we can confirm pgpool
> works as expected. This is similar to PostgreSQL's regression test. We
> maybe able to do similar thing by:
>
> pgpool set client_min_messages to log;
>
> But this has disadvantages:
>
> 1) This will print internal rel cache access log which makes the
> comparison with the expected file unstable because the log is added
> depending on the pgpool relation cache.
>
> 2) The log usually includes process id, again which makes the
> comparison unstable.
>
> notice_per_node_statement does not have these disadvantages.
>
> If we backport notice_per_node_statement, probably we should implement
> it as "undocumented" feature because our policy is "do not backport
> new feature to back branches". I think making it as an undocumented
> feature is a good compromize.
>
> Comments/suggestions are welcome.
If we go forward with this, I plan to push the backport after August
15 (it's pgpool regular minor release date), rather than before.
https://pgpool.net/mediawiki/index.php/Roadmap
Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
More information about the pgpool-hackers
mailing list