Re: Limit length of queryies in pg_stat_statement extension

2025-01-17 Thread Michael Paquier
On Fri, Jan 17, 2025 at 03:24:34PM +0800, Julien Rouhaud wrote: > The real solution is probably to rely on the new > pluggable statistic architecture rather than using the hash table / query text > file. My own plan was to propose exactly that in the v19 cycle, leaving one release with this infras

Re: Limit length of queryies in pg_stat_statement extension

2025-01-16 Thread Julien Rouhaud
Hi, On Thu, Jan 16, 2025 at 10:19:49AM +0800, 赵庭海(庭章) wrote: > Hi all, > Recently, I have noticed a potential problem in the pg_stat_statements > extension. When the garbage collection is triggered within this extension, > if there is a significant amount of data to be written to the > pgss_query

Limit length of queryies in pg_stat_statement extension

2025-01-16 Thread 赵庭海(庭章)
Hi all, Recently, I have noticed a potential problem in the pg_stat_statements extension. When the garbage collection is triggered within this extension, if there is a significant amount of data to be written to the pgss_query_texts.stat file (for example, when tracking very long SQL queries), t