On Fri, Oct 27, 2017 at 4:51 PM, Raúl Marín Rodríguez
<rmrodrig...@carto.com> wrote:
> I've written a small patch to add support for pow() in pgbench.


> The main reason behind it is that I'm currently using a shell call to do it
> which takes between 2-10 ms that can be a big percentage of the time taken
> by the whole transaction. For example (shortened):
> latency average = 11.718 ms
>  - statement latencies in milliseconds:
>          2.834  \setshell POWER2  awk 'BEGIN {p=2^ARGV[1]; print p }'
>          8.846  SELECT
> ST_AsBinary(ST_Simplify(ST_SnapToGrid("the_geom_webmercator",:SNAP),
> I've also updated the related docs and added some tests. Please let me know
> if I'm missing anything.

Please add this patch to the upcoming commit fest if you would like to
get some feedback:

I am adding as well Fabien in CC who worked in getting the internal
function infrastructure in the shape it is now (waaay better) with
commit 86c43f4.

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to