Darafei Praliaskouski

Results 65 comments of Darafei Praliaskouski

Now that @Algunenano has a branch shipping wagyu into PostGIS https://github.com/postgis/postgis/pull/356 this can be done by writing a PostGIS CUnit test, for example.

Here's how it's built for the final postgres module. https://github.com/bytesandbrains/h3-pg/blob/master/Makefile#L80 I tried adding `-DCMAKE_BUILD_TYPE=Release` there but somehow still get functions not inlined in my final build of h3-pg.

I've recreated population_grid_h3_r8 table by re-doing aggregation and now it behaves normally and as expected. Values are like this: ``` 15:10:41 [gis] > select h3_get_Resolution(h3), h3_to_geo(h3), h3 from population_grid_h3_r8 limit...

Other notes: https://gist.github.com/Komzpa/994d5aaf340067ccec0e#gistcomment-3485388

master on -DCMAKE_BUILD_TYPE=Release: ``` kom@nucat:~/proj/h3/build$ bin/benchmarkH3Api -- geoToH3: 0.517386 microseconds per iteration (10000 iterations) -- h3ToGeo: 0.295042 microseconds per iteration (10000 iterations) -- h3ToGeoBoundary: 1.496694 microseconds per iteration (10000 iterations)...

@nrabinowitz feel free to take over it. I currently can't allocate a large chunk of attention to give an estimate when I'll look at it next.

Per https://github.com/uber/h3/pull/326#issuecomment-604544429 flag is `-DCMAKE_BUILD_TYPE=Release`, thanks @isaacbrodsky.

I've spent another couple of hours with it and give up for today. Test is simple: after you build everything right, this should show empty. In non-inlined build it shows...

@zachasme pgbench is an industry standard to benchmark query execution times in postgres.

Side note, disabling fsync is usually a bad idea - disabling synchronous_commit brings the perf improvements without the risks instead.