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 1jQaVm-0005CG-7y for pgsql-docs@arkaria.postgresql.org; Mon, 20 Apr 2020 17:47:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jQaVk-0000Yj-Kr for pgsql-docs@arkaria.postgresql.org; Mon, 20 Apr 2020 17:47:12 +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 1jQaVk-0000Wt-Ef for pgsql-docs@lists.postgresql.org; Mon, 20 Apr 2020 17:47:12 +0000 Received: from mail-qk1-x744.google.com ([2607:f8b0:4864:20::744]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jQaVh-0007w5-AP for pgsql-docs@lists.postgresql.org; Mon, 20 Apr 2020 17:47:11 +0000 Received: by mail-qk1-x744.google.com with SMTP id x66so11579349qkd.9 for ; Mon, 20 Apr 2020 10:47:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=M3YIbDTkv3JAKocPEegu9ep1Fhls/DJZXZDGzp5gNDc=; b=OEcrKE3rGSsJCLrB+3QtdFb2HlH9aHZpMmSrDNzbWZZFxcYlJacz1dsMnt7Iv9dvHd obqLdXfqRXaPVymNUWaOVmCrMo+KOK35cDhvGiqLu2A9qnj+raJkc92QXrT+aQrFUtAX GAIWGXG1cve7tHenJ53+2r9r7zkobnZeHtm1VTRmVw0gAko1s6iaTAhSL2ZJdAADYQk/ TrvSxWkdl/c++ehKZe24b4Z0DDyJR+2Tgtnxa8aj4ufesIAeL6Lcw80c5Rf520A3wkMJ t89oupdZ3y/gabWDNfSxtxEid3eiKqllVICtrrVAsC5vRHkTocW0TTJfrrVcTinvg+MK Iapw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=M3YIbDTkv3JAKocPEegu9ep1Fhls/DJZXZDGzp5gNDc=; b=trx4HmDJBBe1kGX9XDuwy0QOQ3Tknza7wQs12sO9UIcAiglcmRJuQ/kcmPfRkavMcs vsNgQUhGGjcE/Ezk7g8kSFH4ukAZfNM4wijx0lZ9xdr9KhiJQcytZCWCG4amEpW72e3i kRJNwdA5+zwrnJfOFgUJmsHEkVHpExTryaRmS3oREQRfAbF1tFZMVHuORiGWLC7+RaPr GHkCq5vw114X7L7lBLXOrJULs3DFWXBAkzt7nGI60nFrsFszAP1DOFyBa24KZCahgM1C oV7E4V023u2NvPRN8rff5MZaYuftj6wnzj4/8WCgQRf8vRHZ1G+/TiWaE9JjSOPFa39v BitA== X-Gm-Message-State: AGi0PubuteNhgMEdXLI3yfb2BQ1aX983XTUjPyXW9FF73Zn2Q7vYz83U Q/K+D5q2u6bWJPzLWWtBc/Zdrw== X-Google-Smtp-Source: APiQypKPSMFCw5E5OFXSqIqFhcC6xl0MFcdt4R9fo8uVWV/AgVavCZ0nVMNb3RpQpQPUj5EJy+/S5Q== X-Received: by 2002:a37:9145:: with SMTP id t66mr17096759qkd.314.1587404827371; Mon, 20 Apr 2020 10:47:07 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.95.18.252]) by smtp.gmail.com with ESMTPSA id j8sm982769qtk.85.2020.04.20.10.47.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 20 Apr 2020 10:47:06 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 9320D301657; Mon, 20 Apr 2020 13:47:03 -0400 (-04) Date: Mon, 20 Apr 2020 13:47:03 -0400 From: Alvaro Herrera To: tuomo.salo@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: Documentation issue: Default value of temp_buffers Message-ID: <20200420174703.GA15940@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <158738828537.11604.8519749799549110932@wrigleys.postgresql.org> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, On 2020-Apr-20, PG Doc comments form wrote: > https://www.postgresql.org/docs/11/runtime-config-resource.html says: > > ------snip------ > temp_buffers (integer): > Sets the maximum number of temporary buffers used by each database session > [...] The default is eight megabytes (8MB). > ------snap------ > > Are we setting the maximum number of buffers or the maximum total size of > the buffers? Yeah, it's ambiguous. If you give it without units, it's the number of buffers; otherwise it's the size. The docs were updated in version 12 to include this phrase: "If this value is specified without units, it is taken as blocks, that is BLCKSZ bytes, typically 8kB." -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services