On Feb 24, 2013, at 7:16 AM, Rafael Martinez Guerrero <r.m.guerr...@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.7070...@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 <j...@pgexperts.com> CTO, PostgreSQL Experts, Inc. Phone: 1-888-PG-EXPRT x506 FAX: 415-762-5122 http://www.pgexperts.com/