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 1n44zw-00025o-WC for pgsql-hackers@arkaria.postgresql.org; Sun, 02 Jan 2022 17:50: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 1n44zv-00021L-Ip for pgsql-hackers@arkaria.postgresql.org; Sun, 02 Jan 2022 17:50:23 +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 1n44zv-00021B-1z for pgsql-hackers@lists.postgresql.org; Sun, 02 Jan 2022 17:50:23 +0000 Received: from mail-io1-xd2a.google.com ([2607:f8b0:4864:20::d2a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n44zs-00027l-A2 for pgsql-hackers@lists.postgresql.org; Sun, 02 Jan 2022 17:50:22 +0000 Received: by mail-io1-xd2a.google.com with SMTP id u8so38064917iol.5 for ; Sun, 02 Jan 2022 09:50:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=/UCcsv7sATdouSP4AvBu6+94B2BY2tbIHapfbGnGMw4=; b=QlbkWBFO8W0A8valIpQAzre68xv2n3xpm5XH5MgtaGDB9geNWplbR7EaURprdu6Hr0 g0P6O37viQXq/pLiQdJutntm8caeWFjavxMj3nA6H5sGTop8umFc6fMrHVh3d+yXanfm NNwvaQpArb+tGoUefnDRaUgAw51mNWflIIkVNL1gxY8gcnL+YfgLubnh7TEWKdXNOLM1 xtG9WpMuhkb/5efuLZc7RX1lBqBgeQSQupkkeKKGMirO7E4b0z4QLwHhhRVamBfULnAk blxwkqHUE+dzer/dkAxz4vdqwYJQMhN3HnAFHYekGyD3Ih/OnyZxGfKbuXsN+mUH2Dxz GDPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=/UCcsv7sATdouSP4AvBu6+94B2BY2tbIHapfbGnGMw4=; b=KBQCfqtV1lK+OZVvJylS5U/3PPE/3/RCIXJPeysYfOq+pwXhTwBJ7QfRvQ2oNM2W1X Xwx5fgH899DmjQW+dHyy9EsaPB1DuyLdnH48xtuyVLCekTDgK/fZeyoK0YmCw5zVyeie syxUN6aow3jH6IM+VE3sJT/8ophv9qQwuKf3cnyxQAPvO6Iz/Kv9n3Q/lLNhnEEm5171 S80UCmG1ASE5cugjS98ImsksCqYg0QIWwicOW1e+npoUE8Owge3n8cQhmWxgpS2WxQiy 3GpsRHPkqBJNEOeGnwEMB5AjHlUDofC8Bj0gpYwTtHs2SB2vnsBOpGTCnO+RlKGRf0dn ONpQ== X-Gm-Message-State: AOAM533wUZ5p/XQ1rGDXgcJPxq1xYgemw5iy1JuNc6w0wcO9UJewxMEw MnFREO/kma8E+utNyK4cB+GFSknHG+Trnw== X-Google-Smtp-Source: ABdhPJwptEyDlXB6oq/GnwQXSp5CYFA+HMHrmFSfIdS3N7vLf4/hjV1V3DSGHmys+LByeUhoDASvPw== X-Received: by 2002:a05:6602:1604:: with SMTP id x4mr19499549iow.84.1641145817494; Sun, 02 Jan 2022 09:50:17 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id t2sm5651857iob.1.2022.01.02.09.49.46 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 02 Jan 2022 09:49:46 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id EE3F5800DDD; Sun, 2 Jan 2022 11:49:45 -0600 (CST) Date: Sun, 2 Jan 2022 11:49:45 -0600 From: Justin Pryzby To: Tom Lane Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Refactoring the regression tests for more independence Message-ID: <20220102174945.GZ24477@telsasoft.com> References: <1114748.1640383217@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1114748.1640383217@sss.pgh.pa.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Dec 24, 2021 at 05:00:17PM -0500, Tom Lane wrote: > While I've not done so here, I'm tempted to rename > create_function_0 to create_function_c and create_function_3 to > create_function_sql, to give them better-defined charters and > eliminate the confusion with trailing digits for variant files. +1 > (Maybe we should provide a way to run specified test script(s) *without* > invoking the whole schedule first.) +1 ; it can be done later, though. It's nice to be able to get feedback within a few seconds. That supports the idea of writing tests earlier. I guess this may expose some instabilities due to timing of autovacuum (which I'd say is a good thing). If you rearrange the creation of objects, that may provide an opportunity to rename some tables with too-short names, since backpatching would already have conflicts. -- Justin