Tom van Tilburg writes:
> Problem is that the query is not slow, it just stalls and never finishes (
> I waited several hours for a 2 seconds query). Would it still be possible
> to derive an EXPLAIN ANALYZE from it in that case?
No, not really, but it'd be sufficient to compare EXPLAIN (without
Tom van Tilburg writes:
> I have a set of relatively complex queries producing tables (including
> postgis and pgpointcloud functions) that I run consecutively, and sometimes
> (depending on the base-data) my 5th query stalls (CPU 100%, runs forever)
> seemingly on the percentile_cont function.
Hi,
I have a set of relatively complex queries producing tables (including
postgis and pgpointcloud functions) that I run consecutively, and sometimes
(depending on the base-data) my 5th query stalls (CPU 100%, runs forever)
seemingly on the percentile_cont function. *When I replace