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

2013-02-24 Thread Rafael Martinez Guerrero
On 02/22/2013 11:55 PM, j...@pgexperts.com wrote: > > While doing acceptance testing on a new Ubuntu 12.04 PostgreSQL server > running 9.2.3, we set checkpoint_segments = 128, > checkpoint_completion_target = 0.9 and placed pg_xlog on a separate 20G > partition. Also, archive_mode = off on this sy

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

2013-02-24 Thread Jeff Frost
On Feb 24, 2013, at 7:16 AM, Rafael Martinez Guerrero 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 s

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

2013-02-24 Thread Jeff Frost
On Feb 24, 2013, at 1:05 PM, Jeff Frost wrote: > > On Feb 24, 2013, at 7:16 AM, Rafael Martinez Guerrero > 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 pro

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

2013-02-24 Thread Rafael Martinez Guerrero
On 02/24/2013 10:05 PM, Jeff Frost wrote: > > On Feb 24, 2013, at 7:16 AM, Rafael Martinez Guerrero > mailto: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 ou