| From: | "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Transaction wraparound problem with database postgres |
| Date: | 2008-03-21 22:34:21 |
| Message-ID: | 28011CD60FB1724DBA4442E38277F6260896ED41@hermes.computec.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ram Ravichandran | 2008-03-22 00:15:56 | Postgresql partitioning |
| Previous Message | Markus Wollny | 2008-03-21 22:30:31 | Re: Transaction wraparound problem with database postgres |