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 1ngsGP-00062o-IQ for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Apr 2022 18:07:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ngsGO-0002xs-EE for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Apr 2022 18:07:44 +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 1ngsGO-0002xj-2p for pgsql-hackers@lists.postgresql.org; Tue, 19 Apr 2022 18:07:44 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ngsGL-0000f1-4t for pgsql-hackers@postgresql.org; Tue, 19 Apr 2022 18:07:43 +0000 Received: by mail-ej1-x631.google.com with SMTP id u15so34531305ejf.11 for ; Tue, 19 Apr 2022 11:07:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bowt-ie.20210112.gappssmtp.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=aJ6wUNIGJu/nlbELKmCITFrhJAWZi2pGDrcHkyd9f5k=; b=CyKbR9wFaMbUsJSg9ZgQuSqfhgDMsKg+JSDaLkwBn+r/c+GTJTTjb88rO9Q9R1RIYg bm1+mu4Tu6+6Eo55gnb+M2tsypP4YzkW/TWJdFYmBmZ5o8EYxFbTIqERW6dwig4aF7vy t+U4LeJ19PrmgjGjWE1ppYSOLxY+c2+8ZAXQi3AkVsUw9QndtEMfoPTUsPY4d2ZRonhd O/42raJNkkFNgKdL2DBA/fVrIS902T3pGA4GlH+PohSeVY4x5ft+V54i/cnziyIaCOol ANx1QL48P0VsNKHdjpV/LGh670oTQQ3Rn3uN/N86aVnQq+MpavAeA222OoJLbbqKBs/o VTlw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=aJ6wUNIGJu/nlbELKmCITFrhJAWZi2pGDrcHkyd9f5k=; b=U/2KDRWpB/9y+WjaNGmOKRyBWNL3m3nDyStuxHPL+0pmGMnI7Oa8hT8HBH7FhiD3qa xZwqinNX1PaA/J+yIxEIIw3/GvrgSjSdoi1f1W4lYHh0TcrTAHX/EAXzpj/maKES6OSO qlXI+k/mefc/+2U8hD76Kr8lue7hmAallY5YIhLlXLh6+ayaTlF1OtzzNC3bPF7OvbuC ykx0+EnRGgQTVttwA6AC4Zj8/qL4c+r5cwKT34Oi+KFmBe9fDjoooFJnm+vdE+Tr5sNV up27IR0mL0Sx9YTwx/HlYyxekeFhYFH22wmuqtuvwqMyANer01m3uAesJZsCBgZYYo8f KTxw== X-Gm-Message-State: AOAM533zG5XIxwPifgKFG0p42cHpmW/R6J6UlP4EcmpA+q5s6jAwdUy0 kh9g0YuCG+PDxIl7eflN4uwM0eJ0wh7hf7k1w2mJudEdzvnqUQ== X-Google-Smtp-Source: ABdhPJy55RJSgiycksBj+/rSK5CvkteslP/MUnld5H2GxP6mdSnf4q/4XKeVOs0eA0C9V1z5BuQQ1UvomRo+pJQhPSg= X-Received: by 2002:a17:906:ae85:b0:6e8:76c2:1f1f with SMTP id md5-20020a170906ae8500b006e876c21f1fmr15213522ejb.333.1650391660014; Tue, 19 Apr 2022 11:07:40 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Peter Geoghegan Date: Tue, 19 Apr 2022 11:07:14 -0700 Message-ID: Subject: Re: DBT-5 Stored Procedure Development (2022) To: Mahesh Gouru Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 19, 2022 at 11:02 AM Mahesh Gouru wrote: > Please review the attached for my jerry-rigged project proposal. I am seeking to continually refactor the proposal as I can! I for one see a lot of value in this proposal. I think it would be great to revive DBT-5, since TPC-E has a number of interesting bottlenecks that we'd likely learn something from. It's particularly good at stressing concurrency control, which TPC-C really doesn't do. It's also a lot easier to run smaller benchmarks that don't require lots of storage space, but are nevertheless correct according to the spec. -- Peter Geoghegan