Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Date
Msg-id 3041344.1659539825@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries  (bruno da silva <brunogiovs@gmail.com>)
Responses Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries  (bruno da silva <brunogiovs@gmail.com>)
List 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



pgsql-performance by date:

Previous
From: bruno da silva
Date:
Subject: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Next
From: aditya desai
Date:
Subject: pg_wal filling up while running huge updates