Re: Need Multixact Freezing Docs

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Need Multixact Freezing Docs
Date: 2014-04-16 21:32:44
Message-ID: 534EF6FC.80804@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-04-16 21:44:54 Re: assertion failure 9.3.4
Previous Message Alvaro Herrera 2014-04-16 21:28:53 Re: bogus tsdict, tsparser, etc object identities