Re: wal-size limited to 16MB - Performance issue for subsequent backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jesper(at)krogh(dot)cc
Cc: "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: wal-size limited to 16MB - Performance issue for subsequent backup
Date: 2014-10-20 19:39:03
Message-ID: 17733.1413833943@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

jesper(at)krogh(dot)cc writes:
>> configure --with-wal-segsize=something ?

> Yes, but there are good reasons not to go down that route. One is that:

> 1) It looks like I'am going to be the only one, beware of the dragons.
> 2) It requires apparently a re-initdb, thus dump/restore of 4.5TB of data

I think a clean shutdown and pg_resetxlog would be sufficient. I agree
you'd need to do some testing though ...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jesper 2014-10-20 19:41:26 Re: wal-size limited to 16MB - Performance issue for subsequent backup
Previous Message Andres Freund 2014-10-20 19:35:08 Re: wal-size limited to 16MB - Performance issue for subsequent backup