Re: What specific circumstances trigger Autovacuum wraparound

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Daniel Lagerman <spjheruur(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: What specific circumstances trigger Autovacuum wraparound
Date: 2018-06-05 03:47:55
Message-ID: CAKFQuwZC+2cEe-G-L4L3cWAoONBJ=ROjbMg5K7QQ8p=0wWbmYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday, June 4, 2018, Daniel Lagerman <spjheruur(at)gmail(dot)com> wrote:

> I have a pg 9.4.3 server that has one table with calculate age of about
> 320 million, this is the oldest table in this database and therefore the
> age of the DB is the same as the table.
>

It would be advisable to simply upgrade to 9.4.18 and see if any of the
various vacuum related bug fixes solves your problem. That's about the
extent of my useful advice for this...

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-06-05 04:55:13 Re: Code of Conduct plan
Previous Message Jonathan S. Katz 2018-06-05 03:08:21 Re: Code of Conduct plan