Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: "tgarnett(at)panjiva(dot)com" <tgarnett(at)panjiva(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Date: 2015-04-07 21:53:06
Message-ID: 2063708757.1456173.1428443586108.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"tgarnett(at)panjiva(dot)com" <tgarnett(at)panjiva(dot)com> wrote:

> - why didn't vacuum_db -a -F free up more members files?

Are you sure that while the problem was developing the primary
cluster didn't have any long-running transactions (including those
left "idle in transaction" or prepared transactions)? Was there a
checkpoint following the vacuumdb -a -F run?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Timothy Garnett 2015-04-07 22:06:15 Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Previous Message David G. Johnston 2015-04-07 21:01:08 Re: BUG #12991: RESTART IDENTITY is not doing anything