public inbox for [email protected]
help / color / mirror / Atom feedFrom: Mark Wong <[email protected]>
To: Peter Geoghegan <[email protected]>
Cc: Mahesh Gouru <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: DBT-5 Stored Procedure Development (2022)
Date: Mon, 2 May 2022 07:30:23 -0700
Message-ID: <Ym/q/4VpSRRvlkZN@moubin> (raw)
In-Reply-To: <CAE+TzGq_71X5axLiTOWtD3powp5jLSonLvRUQFA2qxoeW0wxRg@mail.gmail.com>
References: <CA+VzgBOVQbQkFxvzgGcYW6_vLGj39=u9X=XAxw_2axR2pQd6vw@mail.gmail.com>
<Yl7/4C2mx/Rnq+dZ@g>
<CAH2-Wzn7WC7Y20mZBiiJkj=Q8YJGiKNnoNnis8fXn15F2Ljj4w@mail.gmail.com>
<YmgtkbIep7TsRcMV@g>
<CAH2-WzkAx1eC0txt4SG7_sHveXjp0Fy8fX8Tu3aA8-WO5cqvCg@mail.gmail.com>
<CAE+TzGq_71X5axLiTOWtD3powp5jLSonLvRUQFA2qxoeW0wxRg@mail.gmail.com>
On Mon, May 02, 2022 at 07:14:28AM -0700, Mark Wong wrote:
> On Tue, Apr 26, 2022, 10:45 AM Peter Geoghegan <[email protected]> wrote:
>
> > On Tue, Apr 26, 2022 at 10:36 AM Mark Wong <[email protected]> wrote:
> > > I'm afraid not. I'm guessing that pulling in egen 1.14 would address
> > > that. Maybe it would make sense to put that on the top of todo list if
> > > this project is accepted...
> >
> > Wouldn't it be a prerequisite here? I don't actually have any reason
> > to prefer the old function-based code to the new stored procedure
> > based code. Really, all I'm looking for is a credible implementation
> > of TPC-E that I can use to model some aspects of OLTP performance for
> > my own purposes.
> >
> > TPC-C (which I have plenty of experience with) has only two secondary
> > indexes (in typical configurations), and doesn't really stress
> > concurrency control at all. Plus there are no low cardinality indexes
> > in TPC-C, while TPC-E has quite a few. Chances are high that I'd learn
> > something from TPC-E, which has all of these things -- I'm really
> > looking for bottlenecks, where Postgres does entirely the wrong thing.
> > It's especially interesting to me as somebody that focuses on B-Tree
> > indexing.
I think it could be done in either order.
While it's not ideal that the kit seems to work most reliably as-is on
RHEL/Centos/etc. 6, I think that could provide some confidence in
getting familiar with something on a working platform. The updates to
the stored functions/procedures would be the same regardless of egen
version.
If we get the project slot, we can talk further about what to actually
tackle first.
Regards,
Mark
view thread (7+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: DBT-5 Stored Procedure Development (2022)
In-Reply-To: <Ym/q/4VpSRRvlkZN@moubin>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox