Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oztoq-0005Aw-DP for pgsql-performance@arkaria.postgresql.org; Tue, 29 Nov 2022 06:10:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oztop-0001gm-0T for pgsql-performance@arkaria.postgresql.org; Tue, 29 Nov 2022 06:10:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oztoo-0001W0-Fb for pgsql-performance@lists.postgresql.org; Tue, 29 Nov 2022 06:10:10 +0000 Received: from pb-smtp21.pobox.com ([173.228.157.53]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oztok-00086d-EF for pgsql-performance@postgresql.org; Tue, 29 Nov 2022 06:10:08 +0000 Received: from pb-smtp21.pobox.com (unknown [127.0.0.1]) by pb-smtp21.pobox.com (Postfix) with ESMTP id E11311DB040; Tue, 29 Nov 2022 01:10:02 -0500 (EST) (envelope-from josh@berkus.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed; d=pobox.com; h=message-id :date:mime-version:subject:to:cc:references:from:in-reply-to :content-type:content-transfer-encoding; s=sasl; bh=dShqp90CYYNF bR8LY4/y9S9QPKw+J5cBBKeiVVClNhI=; b=bTcEeH5AaXnBDqSGEWC1wxb4Kmbl HiI9oqbhG4gIWndEnM6iSE8RayUhtrOG+eaC9Ji+9bQmByP2hPw6XwalMrkt0ipb fwhKZpl6Zjxnwu6k7Knd0zmfSiuvHfyHpPA5Hjg9qcpKdUUYt5b8u4YQvyDmaEcQ 4856V973X0YLF9g= Received: from pb-smtp21.sea.icgroup.com (unknown [127.0.0.1]) by pb-smtp21.pobox.com (Postfix) with ESMTP id CD7A31DB03F; Tue, 29 Nov 2022 01:10:02 -0500 (EST) (envelope-from josh@berkus.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed; d=berkus.org; h=message-id:date:mime-version:subject:to:cc:references:from:in-reply-to:content-type:content-transfer-encoding; s=mesmtp; bh=dShqp90CYYNFbR8LY4/y9S9QPKw+J5cBBKeiVVClNhI=; b=Qvn92cjg7VkOWcfpGaczuRC4ozXRE1gxI5yFjQczq9mH3LH0AxlPc/K5PcqnY8bgKjCkfjG/Lnmdoj36jpd7CeGfmbpN2t4s9fZehEfvjfpICsODm9Ya7fXDd4hIsGk6mhiaFPk1AsfHCHtD/TT7cXKewTcSgpSqxeGK8L3UgWc= Received: from [192.168.132.175] (unknown [71.237.176.63]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pb-smtp21.pobox.com (Postfix) with ESMTPSA id 2CB981DB03A; Tue, 29 Nov 2022 01:09:59 -0500 (EST) (envelope-from josh@berkus.org) Message-ID: <154ee5d9-11d6-005c-9aab-e795493ad837@berkus.org> Date: Mon, 28 Nov 2022 22:09:57 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Subject: Re: Catching up with performance & PostgreSQL 15 Content-Language: en-US To: Justin Pryzby Cc: pgsql-performance@postgresql.org References: <89e7da59-0dfe-45fe-e082-00f777e200a1@berkus.org> <20221129033458.GF11463@telsasoft.com> From: Josh Berkus In-Reply-To: <20221129033458.GF11463@telsasoft.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pobox-Relay-ID: 742A6EEC-6FAC-11ED-8EB2-B31D44D1D7AA-30013111!pb-smtp21.pobox.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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