Re: Improving compressibility of WAL files

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Improving compressibility of WAL files
Дата
Msg-id 200901091431.n09EVW210201@momjian.us
обсуждение исходный текст
Ответ на Re: Improving compressibility of WAL files  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Improving compressibility of WAL files  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Improving compressibility of WAL files  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Tom Lane wrote:
> >> Isn't this redundant given the existence of pglesslog?
> 
> > It does the same as pglesslog, but is simpler to use because it is
> > automatic.
> 
> Which also means that everyone pays the performance penalty whether
> they get any benefit or not.  The point of the external solution
> is to do the work only in installations that get some benefit.
> We've been over this ground before...

If there is a performance penalty, you are right, but if the zeroing is
done as part of the archiving, it seems near zero cost enough to do it
all the time, no?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Including kerberos realm
Следующее
От: Andrew Dunstan
Дата:
Сообщение: parallel restore