For reference, one query which took 10 seconds before now takes 6 seconds. The only change was to upgrade PostGIS and PostgreSQL. And this isn't using all the cool new-ish parallel processing.https://twitter.com/robhawkes/status/1139114417025638400 …
-
-
Replying to @robhawkes
ST_AsMVT will parallelize under the right conditions
2 replies 1 retweet 5 likes -
Replying to @postgis
That's great to hear! Can you shed some light on what the right conditions are? That aspect of parallelisation is still a bit like magic to me right now.
1 reply 0 retweets 0 likes
Replying to @robhawkes
Mostly it’s tied to the number of rows going into the function. (Also, you have to set your various postgresql.conf variables to actually turn it on). https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-MAX-PARALLEL-WORKERS-PER-GATHER …
9:44 AM - 14 Jun 2019
0 replies
0 retweets
1 like
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.