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 1ngsd1-0007Ib-A9 for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Apr 2022 18:31:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ngscy-0005lz-Uk for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Apr 2022 18:31:04 +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 1ngscy-0005lq-JC for pgsql-hackers@lists.postgresql.org; Tue, 19 Apr 2022 18:31:04 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ngscw-0000pT-Ee for pgsql-hackers@postgresql.org; Tue, 19 Apr 2022 18:31:04 +0000 Received: by mail-ot1-x32e.google.com with SMTP id t6-20020a056830224600b00605491a5cd7so5279520otd.13 for ; Tue, 19 Apr 2022 11:31:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=noOEQUc8wmov7aioXEjPwuupoLZYPsCTJkiL6x7mFLE=; b=gZS53rktBQscq8DBwciTskU55B3RU7KDf1YQRW2HpxdD5aRdPPg66hO0k2+PNsz7pV CCEYi/O343rqAq8+NSFTXR9YzI38KL54iOXmJV0UhTFN9iV79poOhoDIMlhhP4ra8jaC uDCwXSUPGUt8lUkvLjJoXoYx4n65SvuOKeeGADdp/CTuro4kprEn2ExQwhtFPLEbglXD gNp3aslJTbZORgYX0aGI4PoxtXbm9lcEVlCkJL5ZYVpasKcTFrBkN1F3x1yYbTnIMK0S dKOw2H9lH65TUP2im7HRE2GIT5u8+HU+Y3aWc6/YTL9PL5RqfYjDWAPj5Zi1ECnXq21/ OLTQ== 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; bh=noOEQUc8wmov7aioXEjPwuupoLZYPsCTJkiL6x7mFLE=; b=7rgqianFWlj+82BR4Uaatmcx/E9sZhXfmjY7c9Oy/pYMAtQ/d4HGXKm6/zPu+cNDKM MazBrYkFy1fODvfUY4444hQ/LjeWd3CrvHFnHNID/bw/ty6zsHVvhacusBG7lAg/19tZ x+3s/DFYyntWGsiStOl/lJK4bY5S2xD6Q+WF43kES/SFax4QDtNjU7mQBJMtNdVamjov UeexDWCXxAw+XazxJT2iKq7J34OpzTIPXr+n0WM57L0vbNCWcNHOCmKRym1fbSIv02Je dMAMFbCiYL7ElrAIk1RlFOGQ/HbbWtOCfL/yBEKYriYgjDOH39Xd1s5K4iR2ycSc+vyZ tL4Q== X-Gm-Message-State: AOAM530COsxXkq0BMPpu8gcGew+FZmhvRFzm2NkoUEPuc1A+j5rzckRs aVuP3YtCjTUokE32UoW64bMYmvK6dmeATg== X-Google-Smtp-Source: ABdhPJzF58r0HCbN3GI/pNhTgLCGQ2tQCmL5uK9aVfvHFzdTAAoGdFy91q//a9TuRm9rKSlnyKgyMA== X-Received: by 2002:a9d:744c:0:b0:605:513d:2c66 with SMTP id p12-20020a9d744c000000b00605513d2c66mr2713956otk.154.1650393060356; Tue, 19 Apr 2022 11:31:00 -0700 (PDT) Received: from g (71-36-115-11.ptld.qwest.net. [71.36.115.11]) by smtp.gmail.com with ESMTPSA id m65-20020acabc44000000b002ed13d0fe6fsm5320949oif.23.2022.04.19.11.30.58 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 19 Apr 2022 11:30:59 -0700 (PDT) Date: Tue, 19 Apr 2022 18:30:56 +0000 From: Mark Wong To: Mahesh Gouru Cc: pgsql-hackers@postgresql.org Subject: Re: DBT-5 Stored Procedure Development (2022) Message-ID: References: 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 Hi Mahesh, On Tue, Apr 19, 2022 at 02:01:54PM -0400, Mahesh Gouru wrote: > Dear all, > > Please review the attached for my jerry-rigged project proposal. I am > seeking to continually refactor the proposal as I can! My comments might briefer that they should be, but I need to write this quickly. :) * The 4 steps in the description aren't needed, they already exist. * May 20: I think this should be more about reviewing the TPC-E specification rather than industry research, as we want to try to follow specification guidelines. * June 20: Random data generation and scaling are provided by and already defined by the spec * Aug 01: A report generator already exists, but I think time could be allocated to redoing the raw HTML generation with something like reStructuredText, something that is easier to generate with scripts and convertible into other formats with other tools As some of tasks proposed are actually in place, one other task could be updating egen (the TPC supplied code.) The kit was last developed again 1.12 and 1.14 is current as this email. Regards, Mark