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 1pk8ub-0001Ds-Ra for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Apr 2023 19:35:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pk8ua-0004Mi-5X for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Apr 2023 19:35:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pk8uZ-0004LT-QJ for pgsql-hackers@lists.postgresql.org; Wed, 05 Apr 2023 19:35:15 +0000 Received: from mail-oa1-x29.google.com ([2001:4860:4864:20::29]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pk8uX-00081s-JH for pgsql-hackers@postgresql.org; Wed, 05 Apr 2023 19:35:14 +0000 Received: by mail-oa1-x29.google.com with SMTP id 586e51a60fabf-177b78067ffso39769395fac.7 for ; Wed, 05 Apr 2023 12:35:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1680723313; 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=C0vuUNKVldSOHOC/cPuVHSVBdkRlTA5fTjL+/xOBMA8=; b=OwnVa04uRxDeBWILdvo32CwJn5xGLuPfqlpa5WPWGYNzbaZS09WCMIcLRUvoO+8WDN /+HP6MNm+qBONzRvY5nMpAWb244UB2v3pnmASaS5C6GKNU/N5wPfxIsnoI3z6FLxN7h3 7WYZmFVAWc0B6peP95LieFoxEYFF6C25H1vah/jMlcD5ckgAsNG3seHJE1vyR88V94MK P/zNlpnLk2ts74RDrzkz4k7xNyU7gNgSO8NC91FT8+6SlwPDCUNunBJW6/e6DGzugAMu zpYGwfk0BZhoQBuTgThofytoFpBFEeviD9C2X4FlSbnh5NwFqdCODyNxEwM2NF+2kmYh 5Baw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680723313; 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=C0vuUNKVldSOHOC/cPuVHSVBdkRlTA5fTjL+/xOBMA8=; b=KNgSTPUKRbZqVcPtuJglEWZW0W8/nZHqpFPww2hxsOaeH0cG2QclFiMZjLIJsUEPJ4 WBxlEudnKqqdUSjQ3pg9nvRYYHNg1/fReepOauBKuDH9CTqYMKTiGOo9JbgFntftR6zB WB7aeC/QGm90/uskUkfHk0BA6dVA9H4HwGxKA9ilKeR54QO0bdixEEXfhTA/tVUPRUtO mQE2X9bE/fNAbM9c4W+3bxaV5gEv0csGe2yfZnPElfQXb5mxl4z/QFb+b+J+JVkgeR49 T08bEteBCUAoMV7Ctu6jfoNuAIYpQxGQE8wL3WQy00sH+2D9cLCYRiyU+11LrqV7LJNo TFNw== X-Gm-Message-State: AAQBX9cH1Tci0EgTLD5APr5fnl/5f23YdqffyGx8aWK1lYV/ebghd1Eg +jLz1NOqgMvTyY+SaqdJBlA9YBdW0p8= X-Google-Smtp-Source: AKy350axHQrvmvh54/r7accOYHupR0PqDHjdmXdgyPsbPpEyZ0xS97dXIhWrXL5sKfPsaZfKPLdMSQ== X-Received: by 2002:a05:6870:527:b0:17e:cb7:29c0 with SMTP id j39-20020a056870052700b0017e0cb729c0mr4015356oao.13.1680723312944; Wed, 05 Apr 2023 12:35:12 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:6dda:ddf6:65e:9e21]) by smtp.gmail.com with ESMTPSA id k1-20020a9d7601000000b006a1793e3571sm7140221otl.61.2023.04.05.12.35.09 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 05 Apr 2023 12:35:11 -0700 (PDT) Date: Wed, 5 Apr 2023 12:35:05 -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: <20230405193505.GA105962@nathanxps13> References: <20230130233040.GA2800702@nathanxps13> <20230404232919.uibzbhjdylk3mlvp@awork3.anarazel.de> <20230405175124.GA31516@nathanxps13> <2020452.1680721630@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2020452.1680721630@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 05, 2023 at 03:07:10PM -0400, Tom Lane wrote: > Seems to me that six rows would be easier to aggregate manually. > An array column seems less SQL-ish and harder to manipulate. +1 -- Nathan Bossart Amazon Web Services: https://aws.amazon.com