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 1qVw42-001dG7-4Y for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Aug 2023 15:34:34 +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 1qVw3z-00FcRv-Tk for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Aug 2023 15:34:32 +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 1qVw3z-00FcRn-Jp for pgsql-hackers@lists.postgresql.org; Tue, 15 Aug 2023 15:34:31 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qVw3x-000IzJ-0p for pgsql-hackers@postgresql.org; Tue, 15 Aug 2023 15:34:31 +0000 Received: by mail-oi1-x235.google.com with SMTP id 5614622812f47-3a7556e4edcso3976609b6e.1 for ; Tue, 15 Aug 2023 08:34:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1692113667; x=1692718467; 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=x+J6kIUBKyp8QFu24qO9N2lD33mrTRW5F/CozUllZrk=; b=RhkPN+JugLVUGk0m+6nMMx61yyAsTlsKnSvbWXJyCCdzskzqx4Ob9vaJjWPsi4LNMh BMXMdixLBv9VF1dHrza0kZJD5HL1iNLwIVTfBUpfdhgLExgD2bIDC+2HsgtQovdRXTHk 9X3PSJuD7VX90EzF4DQW5iWXtNQ5a/S7BRM/4zCqqZNcMlmphCJo9F0Ma1y+MK+V9DAE /tG7UJHeepHrvyUabwBJT5Nd9uThOHq3Sr8eN99aLY4NDHqcshWjswpmc9eAVLzOi9Dj 5eZNMoX1hmuSsxyHb+IOLEjUNrkm7bmZisMOtcuegQQkzlZjKbi1PuB2K7l464oK8ofN Tw1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1692113667; x=1692718467; 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=x+J6kIUBKyp8QFu24qO9N2lD33mrTRW5F/CozUllZrk=; b=IxBjOmbfwtFgEDSLfoUoDXL66Y05dr4V/quasmX1beh0x6P7/aOOb/EYb4csDfjnsL Mof5P+eSdz8eyHlzk1AeaJ0V7KYcG3mT+uNXktM0PgtZKUXafJbcl8Ucrvx9ocD5VQx9 jIOoY0gF67HWqyWcch//5kEWzFoaMMVhhuc4IpObPZwTe+o9t8q/kag1HCuMPAuhV19+ mCSRZFs0W9/+eZzWRRE84IoO1vVeXpcgK/Wgm7gLlSuZ7gws0UjZiAWUe2cy2ahTSf7F apq8yx42tpZCQvyNKGON9gQzrRM4JeHpUZCYuDdaavuPPqmofmD5Gb6FSqSNLcD2GgRJ ek+Q== X-Gm-Message-State: AOJu0YyPv+auawhD0oLzVjGBLGdTSuSLqk14UjE+VJrK5Cqt/+RMWDH/ +Z4N7swp2xRNVLInM51Q6fg= X-Google-Smtp-Source: AGHT+IEY8sM4b5rNLYJQvxCBVry8qWUar3zGNwDyRfbeJp/20Os3RZqYP+gmEMBqMV6hkS5wCi3zwg== X-Received: by 2002:a05:6808:1281:b0:3a7:17b6:34f1 with SMTP id a1-20020a056808128100b003a717b634f1mr1862116oiw.4.1692113666859; Tue, 15 Aug 2023 08:34:26 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:1461:f5a:50a7:967f]) by smtp.gmail.com with ESMTPSA id bk4-20020a0568081a0400b003a77e3c4b75sm5514653oib.47.2023.08.15.08.34.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 15 Aug 2023 08:34:26 -0700 (PDT) Date: Tue, 15 Aug 2023 08:34:23 -0700 From: Nathan Bossart To: Fabien COELHO Cc: Hannu Krosing , pgsql-hackers , Dimitri Fontaine Subject: Re: pgbench - adding pl/pgsql versions of tests Message-ID: <20230815153423.GB2296544@nathanxps13> References: <20230814150737.GA1395427@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Aug 15, 2023 at 09:46:59AM +0200, Fabien COELHO wrote: > I'm unclear about what variety of scripts that could be provided given the > tables made available with pgbench. ISTM that other scenari would involve > both an initialization and associated scripts, and any proposal would be > bared because it would open the door to anything. Why's that? I'm not aware of any project policy that prohibits such enhancements to pgbench. It might take some effort to gather consensus on a proposal like this, but IMHO that doesn't mean we shouldn't try. If the prevailing wisdom is that we shouldn't add more built-in scripts because there is an existing way to provide custom ones, then it's not clear that we should proceed with $SUBJECT, anyway. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com