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
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?
Another point is that, when I remove the percentile_disc function from the
query, the problem is go
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. *W
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 percentile_con
