pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: bruno da silva <brunogiovs@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Date: Wed, 03 Aug 2022 11:17:05 -0400
Message-ID: <3041344.1659539825@sss.pgh.pa.us> (raw)
In-Reply-To: <CAB+Nuk-Pfyvb7bo4MrDjA_vymEd=aOMJO274QZsQRx08aDx5VQ@mail.gmail.com>
References: <CAB+Nuk93fL1Q9eLOCotvLP07g7RAv4vbdrkm0cVQohDVMpAb9A@mail.gmail.com>
	<CAB+Nuk8BT4nroR+AWvka=a9qQxLEfByDC0tNbhY5mG4oaCzwBw@mail.gmail.com>
	<2519232.1659455961@sss.pgh.pa.us>
	<CAB+Nuk9_xmFc0js-JCOiUqQJL978FA4udD4yr4b9ha=3bUj59g@mail.gmail.com>
	<2659868.1659461133@sss.pgh.pa.us>
	<2680918.1659467679@sss.pgh.pa.us>
	<CAB+Nuk-Pfyvb7bo4MrDjA_vymEd=aOMJO274QZsQRx08aDx5VQ@mail.gmail.com>

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





view thread (17+ messages)  latest in thread

Message-ID: <3041344.1659539825@sss.pgh.pa.us>
Permalink:  ../3041344.1659539825@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3041344.1659539825@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, brunogiovs@gmail.com, pgsql-performance@lists.postgresql.org
  Subject: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
  In-Reply-To: <3041344.1659539825@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox