Re: BUG #7902: lazy cleanup of extraneous WAL files can cause out of disk issues

On Feb 24, 2013, at 7:16 AM, Rafael Martinez Guerrero <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> wrote:

> We reported this back in 2011, but we did not get to any conclusion:
> http://www.postgresql.org/message-id/4DE89072.7070305@usit.uio.no
>
> In our case, we had this problem when creating a GIN index.
>
> I think the problem has something to do with checkpoints, I think the
> number of WAL files will grow beyond the limit defined because the
> system can not be finish with checkpoints. A good start to try to
> explain what it is happening would be to try to identify or describe the
> situations where checkpoints can take very long to complete or fail
> altogether.
>
> We are interested in this subject because we have had this problem a few
> times. But we have not been able to identify the reason that triggers this.

Rafael, did you do a followup post on pgsql-performance, or did the thread die at the end of the one you post above?

---
Jeff Frost <jeff(at)pgexperts(dot)com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/