underdarkGIS’s avatarunderdarkGIS’s Twitter Archive—№ 13,667

    1. First results of query aggregating 300 million rows in #Postgres vs #GeoMesa are in: PG (single threaded) 59 min, GeoMesa & SparkSQL 2 min And yes, I know that's in no way a fair comparison
      Permalink On twitter.com Twitter logo underdarkGIS’s avatar ♻️ 4 Retweets ❤️ 21 Favorites Mood +2 🙂
  1. …in reply to @underdarkGIS
    It's too small for GeoMesa to really shine and latest PG versions might already support parallel processing for this query
    On twitter.com Twitter logo underdarkGIS’s avatar ♻️ 3 Retweets ❤️ 4 Favorites Mood +2 🙂
    1. …in reply to @underdarkGIS
      Indeed, PG12 successfully uses parallel query [0]. The optimizer picked 9 (out of 24 potential workers) and runtime is down to 22:39 [0] postgresql.org/docs/12/parallel-query.html
      Permalink On twitter.com Twitter logo underdarkGIS’s avatar ♻️ 1 Retweets ❤️ 4 Favorites Mood +3 🙂