| 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: | Whole Thread | Raw Message | 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,
| 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 |