Скачать или смотреть 5mins of Postgres E9: PostGIS vs GPU, tuning parallel queries, automating Citus benchmarks, HammerDB

In this episode, we talk about PostGIS versus GPU performance for spatial queries and also take a look at using HammerDB and custom automation scripts to benchmark the Citus extension.

Find the article on our blog here: https://pganalyze.com/blog/5mins-post...

Learn more about pganalyze: https://pganalyze.com

📑 What we have discussed in this episode of 5mins of Postgres:

PostGIS vs GPU: Performance and Spatial Joins: https://blog.crunchydata.com/blog/per...

Paul Ramsey on Twitter:   / pwramsey  

PostGis Performance: Performance test suite for PostGIS on GitHub: https://git.osgeo.org/gitea/postgis/p...

How to benchmark performance of Citus and Postgres with HammerDB on Azure: https://www.citusdata.com/blog/2022/0...

Jelte Fennema on Twitter:   / jeltef  

citus-benchmark repository on GitHub: https://github.com/citusdata/citus-be...

5mins of Postgres E2: Using unnest(..), generate_series(), and PostGIS: https://pganalyze.com/blog/5mins-post...

PostGIS vs. Geocoder in Rails: https://pganalyze.com/blog/postgis-ra...

Using GeoDjango and PostGIS in Django: https://pganalyze.com/blog/geodjango-...