Horton

Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: bruno da silva <brunogiovs@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Date: 2022-08-03T15:17:05Z
Lists: pgsql-performance 
bruno da silva <brunogiovs@gmail.com> 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 from 10k to 3k

Whether or not we've fully identified the problem, I think cutting
pg_stat_statements.max is a good idea.  Especially as long as you're
stuck on an unsupported PG version.

			regards, tom lane

Commits

  1. Be more wary about 32-bit integer overflow in pg_stat_statements.