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