Re: pgbench more operators & functions - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pgbench more operators & functions
Date
Msg-id alpine.DEB.2.20.1612021140410.27002@lancre
Whole thread Raw
In response to Re: pgbench more operators & functions  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-hackers
Hello,

> Sorry for the changing the status of the patch against to the current 
> status. While going through the recent mails, I thought that there is 
> some disagreement from committer.

If so, I'm willing to explain again why these operators are useful for 
writing some benchmarks, for instance, this paragraph taken randomly from 
the TPC-B specification, on page 16:

"""  The Account_ID is generated as follows:  • A random number X is generated within [0,1]  • If X<0.85 or branches =
1,a random Account_ID is selected over all <Branch_ID> accounts.  • If X>=0.85 and branches > 1, a random Account_ID is
selectedover all non-<Branch_ID> accounts.
 
"""

This extracy suggests clearly that having some comparison operators and 
some ability to act upon the comparison result is required to implement 
this particular benchmark, which is beyond pgbench current capabilities.

> Moved to next CF with "ready for committer" status.

Ok. We'll see next time what becomes of it...

-- 
Fabien.

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: UNDO and in-place update
Next
From: Vladimir Rusinov
Date:
Subject: Re: s/xlog/wal/ in tools and function names?