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 1pkwHh-0007gQ-L3 for pgsql-hackers@arkaria.postgresql.org; Sat, 08 Apr 2023 00:18:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkwHg-00060E-Iy for pgsql-hackers@arkaria.postgresql.org; Sat, 08 Apr 2023 00:18:24 +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 1pkwHg-000605-7G for pgsql-hackers@lists.postgresql.org; Sat, 08 Apr 2023 00:18:24 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pkwHd-001XX0-4I for pgsql-hackers@postgresql.org; Sat, 08 Apr 2023 00:18:23 +0000 Received: by mail-oi1-x230.google.com with SMTP id e9so18611oig.7 for ; Fri, 07 Apr 2023 17:18:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1680913099; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=mSD76e3HDkIuil1QK/CdTjM6UB92NCmoO6jn/RHFaUQ=; b=n5YWsDj0HQa2R6ns3M8jH8nD5Nu/hLek6cmT+7RJmnnsTfrPHx9NfG0F84c41Br6A+ 1gUNKx55ni787y5kxdNjIaIPW6mZFof+9KtsolJgzAVPBA7p6vDhSye+jMrNapIvE2wg 4KJhhYCWUUrm853XS8NnCh4Q63Ndm7WDzAvmLmjwgZVW2fYlQrtbpArviSnxqbmm3758 bCqJ19re5qES7RZVdkypt/UnupnDKzn/26atVmncSmrbgwMLltdA1nJTP+o0arSSSc0m 0TRdGbP1erIu1Jlu8/LwlEKtfi2evV2Evi/lL761SP/AKTDSQpf69p8r8yJP8KKpTUF/ 7yhQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680913099; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=mSD76e3HDkIuil1QK/CdTjM6UB92NCmoO6jn/RHFaUQ=; b=q5H4ikZePozqd32vKQ5APpAsE7HQA1/sxtcpIlqCiRo2L+2gpTURzuVCL9w36KoNSZ ctV/eV1GqOcWgjc2h7+vMq951sF4Rgv5ec1+WwjYG6/wrc7bg/ZMqfUQBXuKWkGqFx34 u1G0on6xlycuEm6QGNzgqpX5xx7+v8dlyuJ8YH2HfinTbA/35RUOypPaY7Oh9n8NcJDi pQSXPg307y/w3vPUpo6P7kiji6ggPUy6tCZaRwze2nWh32GjpKbDiC/ct3T46FwPUEHL 5JqC98FC+kWhi50Xtdr7Cc/iDj3UaUymDncLgbJxUoay+pwBZahBmRQevQqzEnZ6BsT0 VTWg== X-Gm-Message-State: AAQBX9fchJaKapBJGKuUcaL/J/y0+WQYvS9oMkd8+DzIjOVX7Y6eULtc 4aS9Kr7cDz6ArZIzgLnEgbB+NyJo7II= X-Google-Smtp-Source: AKy350as6OkAXpzYKzRHGEhVyhZjBORcupqdQCKHFkvtmw5Y1ekwFNxORPZPn/dU6/hE0GItrkzo1A== X-Received: by 2002:a05:6808:d9:b0:386:a6f0:5e55 with SMTP id t25-20020a05680800d900b00386a6f05e55mr1732587oic.26.1680913099195; Fri, 07 Apr 2023 17:18:19 -0700 (PDT) Received: from nathanxps13 (162-195-170-173.lightspeed.stlsmo.sbcglobal.net. [162.195.170.173]) by smtp.gmail.com with ESMTPSA id a6-20020a056808120600b003874631e249sm2138989oil.36.2023.04.07.17.18.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 07 Apr 2023 17:18:18 -0700 (PDT) Date: Fri, 7 Apr 2023 17:18:16 -0700 From: Nathan Bossart To: Tom Lane Cc: Robert Haas , Andres Freund , pgsql-hackers@postgresql.org, schneider@ardentperf.com Subject: Re: monitoring usage count distribution Message-ID: <20230408001816.GA519579@nathanxps13> References: <20230405175124.GA31516@nathanxps13> <20230405190921.ck7v4y2h3ogoanvg@awork3.anarazel.de> <20230405194101.GB105962@nathanxps13> <2061855.1680725784@sss.pgh.pa.us> <2478091.1680802355@sss.pgh.pa.us> <20230406180608.GA275542@nathanxps13> <3089322.1680892171@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3089322.1680892171@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Apr 07, 2023 at 02:29:31PM -0400, Tom Lane wrote: > I'm not sure if there is consensus for 0002, but I reviewed and pushed > 0001. I made one non-cosmetic change: it no longer skips invalid > buffers. Otherwise, the row for usage count 0 would be pretty useless. > Also it seemed to me that sum(buffers) ought to agree with the > shared_buffers setting. Makes sense. Thanks! -- Nathan Bossart Amazon Web Services: https://aws.amazon.com