Re: Transaction wraparound problem with database postgres - Mailing list pgsql-general

From Markus Wollny
Subject Re: Transaction wraparound problem with database postgres
Date
Msg-id 28011CD60FB1724DBA4442E38277F6260896ED41@hermes.computec.de
Whole thread Raw
In response to Re: Transaction wraparound problem with database postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> "Markus Wollny" <Markus.Wollny@computec.de> writes:
>> I'd still like to find out what exactly happened here so I can
>> prevent the same from happening again in the future.
>
> Me too.  It would seem that something did a vacuum of postgres with a
> strange choice of xid cutoff, but I can't think of what would cause
> that.
>
> Do you ever do VACUUM FREEZE on your databases?

No, I actually never heard of VACUUM FREEZE, I have to admit.


Computec Media AG
Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818)
Vorstandsmitglieder: Johannes S. Gözalan (Vorsitzender) und Niels Herrmann
Vorsitzender des Aufsichtsrates: Jürg Marquard
Umsatzsteuer-Identifikationsnummer: DE 812 575 276



pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Transaction wraparound problem with database postgres
Next
From: "Ram Ravichandran"
Date:
Subject: Postgresql partitioning