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

help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Need Multixact Freezing Docs
Date: Wed, 16 Apr 2014 14:32:44 -0700
Message-ID: <534EF6FC.80804@agliodbs.com> (raw)
In-Reply-To: <WM!1f13fbd2f441a36e28cf57b12413993c9d5d0160fe7b5fb1dc8ce992c49999a1e658bca73a3d92963640c8cf9f1f69b0!@asav-3.01.com>
References: <534DA3D1.2010000@agliodbs.com>
	<WM!e71c36af513bace4ff046f7349231f370d2b74c4adee803b2eb3ed330aada82b5badd712b47f9556d3fa55d2ab73a3e0!@asav-3.01.com>
	<534DB22A.2040909@agliodbs.com>
	<20140416133233.GL5822@eldon.alvh.no-ip.org>
	<WM!a70b2681d2ac0ed55eb2d3eed44e6730e9c71b5fad8c5320503fde8b18a03fd98a6af6244821ca39d47c1d9e758c45ff!@asav-2.01.com>
	<534EC69B.9010107@agliodbs.com>
	<20140416203057.GQ5822@eldon.alvh.no-ip.org>
	<WM!fa9379a39fd015511ce3872138589081b6e688c26b67a6801364b609b26642096bfd329ce2cb7eb090da00879e59e525!@asav-3.01.com>
	<534EEA8E.5070407@agliodbs.com>
	<20140416204538.GR5822@eldon.alvh.no-ip.org>
	<WM!1f13fbd2f441a36e28cf57b12413993c9d5d0160fe7b5fb1dc8ce992c49999a1e658bca73a3d92963640c8cf9f1f69b0!@asav-3.01.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>


>> So if age() doesn't mean anything, then how are users to know when the
>> need to freeze?
> 
> I don't understand.  Autovacuum will freeze this automatically when the
> threshold is reached.  Users don't need to do anything.

What I'm asking is:

- how do users know if Autovacuum is keeping up with multixact feezing?
- how do users get data on multixact usage so that they can tune the
parameters?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (18+ messages)  latest in thread

Message-ID: <534EF6FC.80804@agliodbs.com>
Permalink:  ../534EF6FC.80804@agliodbs.com/
Also on:    postgresql.org/message-id/534EF6FC.80804@agliodbs.com

 · 

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-hackers@postgresql.org
  Cc: josh@agliodbs.com, alvherre@2ndquadrant.com
  Subject: Re: Need Multixact Freezing Docs
  In-Reply-To: <534EF6FC.80804@agliodbs.com>

* 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