Re: Question about wal_compression and what to expect

Поиск
Список
Период
Сортировка
От Sean O'Grady
Тема Re: Question about wal_compression and what to expect
Дата
Msg-id c36c4be478c2b271600a58281711e4add367d136@hey.com
обсуждение исходный текст
Ответ на Re: Question about wal_compression and what to expect  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-admin
Дерево обсуждения
The internal compression has to compress each record in isolation, which is not nearly as good as compressing the entire file as there are patterns that exist between records not just within records.

I see, that's makes sense. My sense is that wal_compression is really first to alleviate disk IO pressure and secondarily as a space saving benefit. Since I've set about archive_timeout because of a relatively light workload, I probably shouldn't need to worry about IO issues...

Thanks,
Sean

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

Предыдущее
От: Cary Huang
Дата:
Сообщение: Re: SSL cert "not initialized" error with logical replication with 13.11
Следующее
От: Wells Oliver
Дата:
Сообщение: Poor performance due to parallel seq scan on indexed date field