Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUTNI-003Hzm-LK for pgsql-admin@arkaria.postgresql.org; Thu, 18 Jul 2024 15:48:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sUTNG-000k1M-M8 for pgsql-admin@arkaria.postgresql.org; Thu, 18 Jul 2024 15:48:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUTNG-000jys-4r for pgsql-admin@lists.postgresql.org; Thu, 18 Jul 2024 15:48:54 +0000 Received: from mail-ej1-x632.google.com ([2a00:1450:4864:20::632]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sUTNE-000Dwe-8v for pgsql-admin@postgresql.org; Thu, 18 Jul 2024 15:48:53 +0000 Received: by mail-ej1-x632.google.com with SMTP id a640c23a62f3a-a77c9c5d68bso101135166b.2 for ; Thu, 18 Jul 2024 08:48:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1721317730; x=1721922530; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=lTm1bvG/9BJZ4mutvtPms3bD+FlS8jckCVxEn4MzR5c=; b=2GeWuiPJNYgcloMzLQdLS0FHyfAbL4qBMysRFwoOPGDL4Xl3OT4WwQzuL7yNDfWVtx ds212AUIKCWscQ1fBeLv2v9ZQQ0JiGZJBnsFF1IDlYVro4NZKqdvwPlnAgNWuH9FP3De 9uTsUSHVolxpR2imB4JtHkiERzqoDqgGYUUAmBZoA9yZ4wBmVLjtyJrjJ2d0YtSVoKQv ClX4zm3btK+F/qxoaFxFgDzmAvvm8btSEo3M63yOR06b5j7czVtU9trcariwpewTmvwB xSm8ae4Yil2r/ZTragGhXH4uYFqu6Nhz1kAi2Jq/nM4UZNiNw0aKtKQ0BxI/55CXMBwb GALg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721317730; x=1721922530; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=lTm1bvG/9BJZ4mutvtPms3bD+FlS8jckCVxEn4MzR5c=; b=T8ccyW7zQZqtHDXQWUlA0Uji+G6sqPyEr9s0/Q7MxlhPJJFHz6/baC6sr5p3pkQN4G y9NDFh4Sc4kJYSLY/bPh6KC5dFRZTZ4/RkvnvNAqz6T6Eb1O5ujd9A3og+KAqZapaEJF qJRCVRf1qLy4kT0eXRBaVkoDLb6r7tZJmw8ilPwdj1GvQqDq1yVf3Y8P4yxab1pOWi2D cWs1Pcaj7h00w9qQcbOC1rQ7h7w1v18ZgU7h7ClLu2iwpDc20fcAkQATIEl4TUAt1Vnn EesjB/WpCIl/n/u7XJbfBStHckzjOSsBqpH9ILLFAqN/YkWaBd79Mr0Rb6jjEppRj+ja 1wpg== X-Forwarded-Encrypted: i=1; AJvYcCVLxWSpOVqYtm8s4hro1OyHca3A4SJ1Ae5zxCa3w6q6f5/K6lgVOTa5eTlPOtQUUWeqGHjRG3U+U9kFoM9Xb1rbWeC2pbiflbsa6A== X-Gm-Message-State: AOJu0YyB0i1XJnhZGES+dfbNSkG67WnRLczZXNkLYwQMASY3e6NiHyK0 9jSqJhfe5vkTIXUJNSez2HLxJVIpuHmOmDy4a3Mt+RPFRsUStV4yHKtoEqQ4J7M= X-Google-Smtp-Source: AGHT+IHYk9IXT95ERzfIqqE5LzMjrdmh/le122wdxnADlY6SNn+/uEQuXWKnd0OdfsRXgIGhjY0EzA== X-Received: by 2002:a17:906:e0ce:b0:a6f:dc17:500a with SMTP id a640c23a62f3a-a7a0114c017mr368064366b.23.1721317729942; Thu, 18 Jul 2024 08:48:49 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:4dc2:a8ee:5c26:dd12:c8ae]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a79bc5a395asm575506666b.29.2024.07.18.08.48.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 18 Jul 2024 08:48:49 -0700 (PDT) Message-ID: <191aa8370a6d796c19473a42b7902718952252ec.camel@cybertec.at> Subject: Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup From: Laurenz Albe To: Veerendra Pulapa , pgsql-admin , Pgsql-admin Date: Thu, 18 Jul 2024 17:48:48 +0200 In-Reply-To: References: Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2024-07-18 at 21:03 +0530, Veerendra Pulapa wrote: > I hope you=E2=80=99re all doing well. We=E2=80=99re currently evaluating = hardware options for our > PostgreSQL setup, specifically focusing on CPU and RAM. We=E2=80=99d love= to hear your insights > on the following: >=20 > CPU: > =C2=A0* Optimal number of cores? > =C2=A0* Impact of clock speed? > =C2=A0* Preferred CPU architectures? > RAM: > =C2=A0* Recommended amount? > =C2=A0* Importance of memory bandwidth? > =C2=A0* Buffer cache configuration tips? >=20 > Any advice or experiences you can share would be greatly appreciated. You= r input will > help us make informed decisions and optimize our setup. How big is the database going to be? How many transactions per second do you expect? How many concurrent statements will you have to handle? What kind of workload is it going to be? OLTP? Analytical? Mixed? Yours, Laurenz Albe