Re: Catching up with performance & PostgreSQL 15

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Catching up with performance & PostgreSQL 15
Дата
Msg-id 154ee5d9-11d6-005c-9aab-e795493ad837@berkus.org
обсуждение исходный текст
Ответ на Re: Catching up with performance & PostgreSQL 15  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
On 11/28/22 19:34, Justin Pryzby wrote:
> In addition to setting work_mem, you can also (since v13) set
> hash_mem_multiplier.

Is there any guidance on setting this?  Or is it still "use the default 
unless you can play around with it"?

> default_toast_compression = lz4 # v14
> recovery_init_sync_method = syncfs # v14
> check_client_connection_interval = ... # v14
> wal_compression = {lz4,zstd} # v15

If anyone has links to blogs or other things that discuss the 
performance implications of the above settings that would be wonderful!

-- 
Josh Berkus




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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: Catching up with performance & PostgreSQL 15
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Catching up with performance & PostgreSQL 15