Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated) - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Date
Msg-id 2063708757.1456173.1428443586108.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)  (tgarnett@panjiva.com)
Responses Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)  (Timothy Garnett <tgarnett@panjiva.com>)
List pgsql-bugs
Tree view 
"tgarnett@panjiva.com" <tgarnett@panjiva.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

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #12991: RESTART IDENTITY is not doing anything
Next
From: Michael Paquier
Date:
Subject: Re: PQexec() hangs on OOM