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

From Fabien COELHO
Subject Re: [HACKERS] pgbench more operators & functions
Date
Msg-id alpine.DEB.2.20.1712221134300.7724@lancre
Whole thread Raw
In response to Re: [HACKERS] pgbench more operators & functions  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
Hello Teodor,

>> replaced -1 by 0xffff.... so that the code is hopefully clearer.
> I changed 0xff constant  to  ~INT64CONST(0), seems, it's more consistent way.
> Also I remove some whitespaces in exprparse.y. Fixed version in attachment.

Fine, quite readable this way.

> Actually, I prefer to see single scripting implementation in both psql and 
> pgbench,

I'll push for the implementations are to share more stuff in the future.

For instance the pgbench-if patch shares the conditional stack 
implementation. I intend to move pgbench expression engine as a shared 
front-end util, once its capabilites are extended and stable, which is 
basically after this patch, so that client side expressions can be used in 
psql.

Now, psql & pgbench contexts are slightly different, with an interactive 
thing which must evaluate on the fly on one side and a scripting thing on 
the other, so it would not be easy to share everything or to do everything 
the same way.

> but I suppose nobody has a power to do it in foreseen future. And, 
> may be, it's not a very good way  to invent one script language instead of 
> using one of bunch of them, but, again, I'm afraid several months/years 
> discussion about how and which one to embed. But scripting is needed now, I 
> believe, at least I see several test scenarios which can not be implemented 
> with current pgbench and this patch allows to do it.

That is exactly why I'm pushing different things into pgbench (\gset, 
\if, ...), to improve capabilities wrt to benchmarking.

> So, I intend to push thish patch in current state. I saw several objections 
> from commiters in thread, but, seems, that objections are lifted. Am I right?

I think so.

-- 
Fabien.


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: [HACKERS] pgbench more operators & functions
Next
From: Ildar Musin
Date:
Subject: Re: General purpose hashing func in pgbench