tried to reanable charts to see how they behave with the web-workers. it doesn't lock up fe, which is good. but it still locks up delivery queue, while its gathering data.
question: what will…
can confirm that the split works well with on my instance. now lockdowns of fe anymore even when queue is doing its thing. i still have to disable charts tho, but thats another issue. at least it…
EXPLAIN on the query shows me 2 parts with an awefull high cost
-> Hash Join (cost=591010.12..1640990.66 rows=5586168 width=2937) (actual time=53684.512..53723.567 rows=1 loops=1)
a…
considering that this seems to be an issue with drive files, i suspect FoundKeyGang/FoundKey#143 is maybe related to this
Just for completness. merged it yesterday, seems to run well so far. will keep it for a week without the charts stuff, than enable charts again to see how it runs with them