Re: increasing the default WAL segment size

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: increasing the default WAL segment size
Дата
Msg-id 20160825132524.GA2830@momjian.us
обсуждение исходный текст
Ответ на Re: increasing the default WAL segment size  (Claudio Freire <klaussfreire@gmail.com>)
Ответы Re: increasing the default WAL segment size  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
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.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Write Ahead Logging for Hash Indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Intermittent "cache lookup failed for type" buildfarm failures