Re: wal-size limited to 16MB - Performance issue for subsequent backup - Mailing list pgsql-hackers

From Tom Lane
Subject Re: wal-size limited to 16MB - Performance issue for subsequent backup
Date
Msg-id 17733.1413833943@sss.pgh.pa.us
Whole thread Raw
In response to Re: wal-size limited to 16MB - Performance issue for subsequent backup  (jesper@krogh.cc)
List pgsql-hackers
jesper@krogh.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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: wal-size limited to 16MB - Performance issue for subsequent backup
Next
From: jesper@krogh.cc
Date:
Subject: Re: wal-size limited to 16MB - Performance issue for subsequent backup