Re: increasing the default WAL segment size
От | Michael Paquier |
---|---|
Тема | Re: increasing the default WAL segment size |
Дата | |
Msg-id | CAB7nPqSQzvucB635Yp0+9JrcbDGHwcBDdxKNb-wDGLw-UFUruQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: increasing the default WAL segment size (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: increasing the default WAL segment size
|
Список | pgsql-hackers |
On Thu, Aug 25, 2016 at 10:25 PM, Bruce Momjian <bruce@momjian.us> wrote: > On Wed, Aug 24, 2016 at 10:40:06PM -0300, Claudio Freire wrote: >> > time instead of requiring a recompile; we probably don't save any >> > significant number of cycles by compiling this into the server. >> >> FWIW, +1 >> >> We're already hurt by the small segments due to a similar phenomenon >> as the ssh case: TCP slow start. Designing the archive/recovery >> command to work around TCP slow start is quite complex, and bigger >> segments would just be a better thing. >> >> Not to mention that bigger segments compress better. > > This would be good time to rename pg_xlog and pg_clog directories too. That would be an excellent timing to do so. The first CF is close by, and such a change would be better at the beginning of the development cycle. -- Michael
В списке pgsql-hackers по дате отправления: