Re: gaussian distribution pgbench - Mailing list pgsql-hackers

From KONDO Mitsumasa
Subject Re: gaussian distribution pgbench
Date
Msg-id 53145E81.2080700@lab.ntt.co.jp
Whole thread Raw
In response to Re: gaussian distribution pgbench  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: gaussian distribution pgbench  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
(2014/03/03 16:51), Fabien COELHO wrote:>>>    \setrandom foo 1 10 [uniform]>>>    \setrandom foo 1 :size gaussian
3.6>>>   \setrandom foo 1 100 exponential 7.2>> It's good design. I think it will become more low overhead at part of
parsing>>in pgbench, because comparison of strings will be redeced(maybe). And I'd like>> to remove [uniform], beacause
wehave to have compatibility for old scripts,>> and random function always gets uniform distribution in common sense
of>>programming.>> I just put "uniform" as an optional default, hence the brackets.
 
All right. I was misunderstanding. However, if we select this format, I'd like to 
remove it. Because pgbench needs to check counts of argment number. If we allow 
brackets, it will not be simple.
> Otherwise, what I would have in mind if this would be designed from scratch:>>    \set foo 124>    \set foo "string
value"(?)>    \set foo :variable>    \set foo 12 + :shift>> And then>>    \set foo uniform 1 10>    \set foo gaussian 1
104.2>    \set foo exponential 1 100 5.2>> or maybe functions could be repended with something like "&uniform".> But
thatwould be for another life:-)
 
I don't agree with that.. They are more overhead in parsing part and more complex 
for user.
>> However, new grammer is little bit long in user script. It seems trade-off that>> are visibility of scripts and user
writingcost.>> Yep.
 
OK. I'm not sure which idia is the best. So I wait for comments in community:)

Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: GSoC proposal
Next
From: Michael Paquier
Date:
Subject: Re: Review: Patch FORCE_NULL option for copy COPY in CSV mode