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 1qGPen-000566-46 for pgsql-admin@arkaria.postgresql.org; Mon, 03 Jul 2023 19:56:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qGPel-0006Qo-0J for pgsql-admin@arkaria.postgresql.org; Mon, 03 Jul 2023 19:56:19 +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 1qGPek-0006Qf-Lw for pgsql-admin@lists.postgresql.org; Mon, 03 Jul 2023 19:56:18 +0000 Received: from mail-yb1-xb31.google.com ([2607:f8b0:4864:20::b31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qGPeh-0020q7-Oq for pgsql-admin@lists.postgresql.org; Mon, 03 Jul 2023 19:56:18 +0000 Received: by mail-yb1-xb31.google.com with SMTP id 3f1490d57ef6-c2743325e2dso6989820276.1 for ; Mon, 03 Jul 2023 12:56:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688414173; x=1691006173; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=YIifsNlxmvtem/JQC1lnTn8fDke5MYnpVoVLgrfN/Q8=; b=otChSC21iZVsBFydxxDXF2GHBfs47cgBxqSqxS394n3nCHx1IjBlO1XIlZJI4cSrpu jMiPK1kkkSkkjKCQmU7zOcRGGMipzhDeMMNjNqweERgU5G4DYaM8a6E3AUY9u3w5dRbG 2n4G6e9d6A12HYDg5a1jZ8xA2zthKacaidyo7qLJeKrerG6lIZFgH4OTJJAOaYW9kAwf rl2mq05xrpF50/mAfbV8oHtbUszjptpOVAFpzQ9VBoj6saVC8uMEqO/mh3wvPpsQ1B71 whJXiFhCOlO7yAD9HpTz8DiKkYQqT1Dfa57+hPEGeJH89sEWh+n86qIPq98KG1/dILFD hVgg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688414173; x=1691006173; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=YIifsNlxmvtem/JQC1lnTn8fDke5MYnpVoVLgrfN/Q8=; b=XXyPEynnIw/FMRIif8aralDJYy74DqOTj0/NMUJPUqby54UWPEmFqVnju/2NZXms9/ gCkH1M83ZVDSQQ7hJVku2QQITw2r298yfjxN1+bU+ILtscy/awJQNMW8rJFHDKR0uxWR CiFBcY+qdn8eGujv/k8XvNg9JH2NMQdJy/Lw3BQGlpAIb3T1YeJhtu9WqDlhdi37NUKO meoGYMx0N5Min+NnkDbLdxZtTcEUKHFyOWQ7yW9TcAfFmIzM8J9mudeOJfZSWHlW1M+m LllMFrJdSnvWwcTEKn3O28XQh09wFfz2bDK5VL313cLzEimzwWZqj0X2mexzd30iWPaF RSLQ== X-Gm-Message-State: ABy/qLYbSPJ20Sh/b8/1GIvIuXWDqjrS2syrHMINUu8v0TRfwy64Dfto 8Y87JB9KSjGTU+6rMcSNA6sUb0HZj5k= X-Google-Smtp-Source: APBJJlH4qi8/tt1e50vYFMZJbmd8fjBN7mdmpKX2KNNZ4UMHNUZIRg4ypXQ3+6o52xvmnPqsWz+j8Q== X-Received: by 2002:a25:e70d:0:b0:bfe:c4c8:66fd with SMTP id e13-20020a25e70d000000b00bfec4c866fdmr15390592ybh.4.1688414172945; Mon, 03 Jul 2023 12:56:12 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:14c:97f7:8118:3fbf? ([2600:1700:bd2c:b810:14c:97f7:8118:3fbf]) by smtp.googlemail.com with ESMTPSA id w143-20020a25df95000000b00bcae3682a51sm4616952ybg.47.2023.07.03.12.56.12 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 03 Jul 2023 12:56:12 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------kSzvjyOqJ9rQlB1TjvfoEhTG" Message-ID: <4b1c1747-85ff-f174-a43b-482e580fe6a2@gmail.com> Date: Mon, 3 Jul 2023 14:56:12 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Sanity check of shared_buffers value Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------kSzvjyOqJ9rQlB1TjvfoEhTG Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 7/3/23 14:45, Wells Oliver wrote: > Sorry, this is dumb, but I wanted to double check that I'm doing the > shared_buffers calc correctly given it's in 8kb blocks (block_size is set > to 8192). > > Want 24GB, which I think is 25165824 KiB so divided by 8 we get 3145728. > > Do I have this correct? Usually can test these but wanted to run it by > someone before having to restart the server. > > Is there some calc web service out there that idiots such as myself can > use for this? https://www.postgresql.org/docs/15/runtime-config-resource.html "If this value is specified *without **units*, it is taken as blocks," My interpretation of this (and what I do in my postgresql.conf file, without error) is to use a unit name, as such: shared_buffers = 24GB -- Born in Arizona, moved to Babylonia. --------------kSzvjyOqJ9rQlB1TjvfoEhTG Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 7/3/23 14:45, Wells Oliver wrote:
Sorry, this is dumb, but I wanted to double check that I'm doing the shared_buffers calc correctly given it's in 8kb blocks (block_size is set to 8192).

Want 24GB, which I think is 25165824 KiB so divided by 8 we get 3145728.

Do I have this correct? Usually can test these but wanted to run it by someone before having to restart the server.

Is there some calc web service out there that idiots such as myself can use for this?

https://www.postgresql.org/docs/15/runtime-config-resource.html

"If this value is specified without units, it is taken as blocks,"

My interpretation of this (and what I do in my postgresql.conf file, without error) is to use a unit name, as such:
shared_buffers = 24GB

--
Born in Arizona, moved to Babylonia.
--------------kSzvjyOqJ9rQlB1TjvfoEhTG--