[NOVICE] max_wal_size & compression on compressed filesystem

Поиск
Список
Период
Сортировка
От Stephen Froehlich
Тема [NOVICE] max_wal_size & compression on compressed filesystem
Дата
Msg-id DM5PR06MB28915972F3037331CD6E19F4E54C0@DM5PR06MB2891.namprd06.prod.outlook.com
обсуждение исходный текст
Список pgsql-novice

Hi All,

 

I am running postgres on top of zfs with lz4 enabled, so of course wal compression is off.  I know that the wal size is then set for the uncompressed size as postgres is completely unaware of zfs’s compression happening under the hood.

 

So, to get the WAL size “right” given my space constraints (a fast ~250 GB partition on an SSD), I either need to multiply max_wal_size by my expected compression ratio (looks like about 4:1) or turn wal_compression on (which assume would result in a small speed hit).

 

Thoughts?

 

 

Stephen Froehlich
Sr. Strategist, CableLabs®


s.froehlich@cablelabs.com

Tel: +1 (303) 661-3708

 

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [NOVICE] Executing prepared statements in the multithreaded envs
Следующее
От: Ruslan R. Laishev
Дата:
Сообщение: [NOVICE] PQprepare & Stored Proces & OUT parameters