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.m.guerrero@usit.uio.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
>=20
> In our case, we had this problem when creating a GIN index.
>=20
> 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.
>=20
> 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@pgexperts.com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/=20