postgres 9.4.5 - pg_serial not decreasing

From: Alexandre Garcia <alexandre(at)vmfarms(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgres 9.4.5 - pg_serial not decreasing
Date: 2016-06-07 18:23:09
Message-ID: CAPYLKR5BJaFyivc0w=x7rswrmE5NxCGi2W7_bdYd14xQ26JOoQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

Few weeks ago our customer experienced some spikes on his Postgres 9.4.5
database. We've been alerted of a significant disk usage increase and
pg_serial seemed to be the culprit.

We noticed a lot of those errors in the logs

" could not truncate directory "pg_serial": apparent wraparound "

No more errors now but the pg_serial is still 8G big and doesn't seem to
decrease.
The only thing I could find related to this was an old bug from 2011 which
might be fixed now.

We wonder what is responsible for cleaning up the old transactions in
pg_serial and how it could dysfunction in this case.

Would you have any clue ?

Cheers,

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Max Kremer 2016-06-07 19:45:21 Planner is ignoring index when view is queried but uses index when running underlying view's sql
Previous Message Patrick B 2016-06-06 23:53:14 Re: WAL segment NOT FOUND - Postgres 9.2