bruno da silva writes:
> *Question: *Besides the gc issue that you mentioned, having a large ( 700MB
> or 1GB ) pgss_query_texts.stat could cause slowness in pg_stat_statement
> processing
> than leading to slower query responses with a 32bit PG? I'm thinking in
> reducing pg_stat_statements.max f
Hello Tom. Thanks for your response.
I spent most of the time looking for evidence and checking other
installations with similar patterns since your response.
this installation is in the habit of doing pg_stat_statements_reset() a lot?
* resetting is very rare. How can I get "pgss->mean_query_len"
Hello David,
Thank you for the valuable inputs.We will test these scenarios .
Regards,
Ameya
On Tue, Aug 2, 2022 at 12:16 PM David Rowley wrote:
> On Tue, 2 Aug 2022 at 19:48, Ameya Bidwalkar
> wrote:
> > We have a Postgresql 13 database where we have a single table with
> several millions of
