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

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike Schanne <mschanne@kns.com>
Cc: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: Re: autovacuum locking question
Date: Fri, 06 Dec 2019 12:12:19 -0500
Message-ID: <16067.1575652339@sss.pgh.pa.us> (raw)
In-Reply-To: <1f62dd52283e4aa3b5d730d546cc4c02@USEPRDEX1.corp.kns.com>
References: <0871fcf35ceb4caa8a2204ca9c38e330@USEPRDEX1.corp.kns.com>
	<26221.1575589746@sss.pgh.pa.us>
	<1f62dd52283e4aa3b5d730d546cc4c02@USEPRDEX1.corp.kns.com>

Mike Schanne <mschanne@kns.com> writes:
> Is this what you are referring to?
> - Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction (Nathan Bossart, Jeremy Schneider)
> This case would lead to VACUUM failing until the old transaction terminates.
> https://www.postgresql.org/docs/release/9.6.16/

Hmmm ... after digging through the commit log, it seems the improvements
I was thinking of were all pre-9.6.  The only post-9.6 vacuum truncation
performance fix I can find is

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=7e26e02ee

which came in in v10.

			regards, tom lane

view thread (13+ messages)  latest in thread

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

copy link · copy postgr.es

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, mschanne@kns.com
  Subject: Re: autovacuum locking question
  In-Reply-To: <16067.1575652339@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