pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Giorgio Saviane <gsaviane@gmail.com>
Cc: Francisco Olarte <folarte@peoplecall.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain
Date: Sat, 12 Sep 2020 14:18:04 -0400
Message-ID: <653162.1599934684@sss.pgh.pa.us> (raw)
In-Reply-To: <CAHs6c0fTSor3WHd_CSsGThtOSAgO2PAcCT+M+uF7hcgQsQvYtQ@mail.gmail.com>
References: <16614-23e5c4c4567d1576@postgresql.org>
	<182231.1599749034@sss.pgh.pa.us>
	<20200911063036.GH2743@paquier.xyz>
	<371035.1599834081@sss.pgh.pa.us>
	<CAHs6c0dK+tOx_RiZ1BSKw9sZSPdJUF+-87fYi0D8fNdXT-Rbiw@mail.gmail.com>
	<CA+bJJbyw8ZNzZRD33VvP7FZho5QpBWy4GXXR1g6iZA9Xm61xAA@mail.gmail.com>
	<CAHs6c0cs5PtQffn9Nt_sW99ncGBjvKJ01wy+1anUn_4J2cysVA@mail.gmail.com>
	<553829.1599925774@sss.pgh.pa.us>
	<CAHs6c0fTSor3WHd_CSsGThtOSAgO2PAcCT+M+uF7hcgQsQvYtQ@mail.gmail.com>

Giorgio Saviane <gsaviane@gmail.com> writes:
> Ok, let me add one more step in that sequence.
> Before shutting down Postgres and going down to single mode we stopped the
> application server and other services around it. I'm pretty sure that there
> was a reasonable window of time before we went to single mode.

Hmm, but did you stop the connection pooler?  That's what was holding
the database session open, if I'm understanding things correctly.

Unless you've changed the default autovacuum settings (particularly
autovacuum_naptime), I'd have expected autovacuum to start zapping
temp tables within a minute or so after they become orphaned.
Even more to the point, if the database session was allowed to stop
normally, it should've cleaned them up itself.

			regards, tom lane





view thread (13+ messages)  latest in thread

Message-ID: <653162.1599934684@sss.pgh.pa.us>
Permalink:  ../653162.1599934684@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/653162.1599934684@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-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, gsaviane@gmail.com, folarte@peoplecall.com, michael@paquier.xyz, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain
  In-Reply-To: <653162.1599934684@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