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 1ozqqk-0004rY-EX for pgsql-performance@arkaria.postgresql.org; Tue, 29 Nov 2022 02:59:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ozqqj-0006Ap-9P for pgsql-performance@arkaria.postgresql.org; Tue, 29 Nov 2022 02:59:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ozqqi-0006Ae-Ml for pgsql-performance@lists.postgresql.org; Tue, 29 Nov 2022 02:59:57 +0000 Received: from pb-smtp21.pobox.com ([173.228.157.53]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ozqqe-0003yD-UG for pgsql-performance@postgresql.org; Tue, 29 Nov 2022 02:59:55 +0000 Received: from pb-smtp21.pobox.com (unknown [127.0.0.1]) by pb-smtp21.pobox.com (Postfix) with ESMTP id 101101D9F61 for ; Mon, 28 Nov 2022 21:59:48 -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:to:from:subject:content-type :content-transfer-encoding; s=sasl; bh=Me2Mg+++DbOmusu7CEQTnI9vg BzFBns7xBuMuGW1adQ=; b=RVyKRXlnVvvWeFAXUA0eF/GLOECaFSE5dB9BEG3BY Tu8XWmvHBWMmToADfCicR5HNVxPhAG74K9rl00rBGlZwDcCt+TXN1GPtPV3f3j59 muroApW8y3gxZSLlMrAjm4DU89y723yCfVXV6dpGZ6T9cqbEInNldeQJl3bM6V7L v8= Received: from pb-smtp21.sea.icgroup.com (unknown [127.0.0.1]) by pb-smtp21.pobox.com (Postfix) with ESMTP id 08A5B1D9F60 for ; Mon, 28 Nov 2022 21:59:48 -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:to:from:subject:content-type:content-transfer-encoding; s=mesmtp; bh=Me2Mg+++DbOmusu7CEQTnI9vgBzFBns7xBuMuGW1adQ=; b=oLZNuxTnzZ904mTM65jhcs2cnr1oKSWafW5rL+N1btHf9JlCqDMvreeSRnMv6Svab/lvuMSZOhisLLxV0KZ1xd5DDXx33WNVpINZk5QpuUoDJLaasrwXfX0Z87ZlTFHFhNw2QDe7xKA758MyAqgAMLSEh5y3d81jc2oWj54qmCI= 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 4FC931D9F55 for ; Mon, 28 Nov 2022 21:59:44 -0500 (EST) (envelope-from josh@berkus.org) Message-ID: <89e7da59-0dfe-45fe-e082-00f777e200a1@berkus.org> Date: Mon, 28 Nov 2022 18:59:41 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Content-Language: en-US To: pgsql-performance From: Josh Berkus Subject: Catching up with performance & PostgreSQL 15 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pobox-Relay-ID: E05E2D58-6F91-11ED-B14D-B31D44D1D7AA-30013111!pb-smtp21.pobox.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hey, folks: I haven't configured a PostgreSQL server since version 11 (before that, I did quite a few). What's changed in terms of performance configuration since then? Have the fundamentals of shared_buffers/work_mem/max_connections changed at all? Which new settings are must-tunes? I've heard about new parallel stuff an JIT, but neither is that applicable to my use-case. -- Josh Berkus