Re: Catching up with performance & PostgreSQL 15 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Catching up with performance & PostgreSQL 15
Date
Msg-id 154ee5d9-11d6-005c-9aab-e795493ad837@berkus.org
Whole thread Raw
In response to Re: Catching up with performance & PostgreSQL 15  (Justin Pryzby <pryzby@telsasoft.com>)
List 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 by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Catching up with performance & PostgreSQL 15
Next
From: Alvaro Herrera
Date:
Subject: Re: Catching up with performance & PostgreSQL 15