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 2519232.1659455961@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:
> After more investigation, we found that pgss_query_texts.stat of a size of
> 2.2GB. and this deployment has a 32bit pg.

Hm ... we've heard one previous report of pg_stat_statements' query text
file getting unreasonably large, but it's not clear how that can come
to be.  Do you have a lot of especially long statements being tracked
in the pg_stat_statements view?  Are there any other signs of distress
in the postmaster log, like complaints about being unable to write
pgss_query_texts.stat?

            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: Robert Blayzor
Date:
Subject: Re: PgSQL 14 - Logical Rep - Single table multiple publications?