Re: Postgres sometimes stalling on 'percentile_cont'

2018-07-05 Thread Tom van Tilburg
E noisemodel.blocks ( gridid text, blockid bigint, geom geometry ) WITH ( OIDS=FALSE ); On Wed, Jul 4, 2018 at 6:01 PM, Tom Lane wrote: > Tom van Tilburg writes: > > I have a set of relatively complex queries producing tables (including > > postgis and pgpointcloud functions)

Postgres sometimes stalling on 'percentile_cont'

2018-07-04 Thread Tom van Tilburg
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