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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bruno da silva <brunogiovs(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Date: 2022-08-02 15:59:21
Message-ID: 2519232.1659455961@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

bruno da silva <brunogiovs(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Blayzor 2022-08-02 16:09:58 Re: PgSQL 14 - Logical Rep - Single table multiple publications?
Previous Message bruno da silva 2022-08-02 15:08:05 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries