Re: Query Crashes PG 10.3 using partitions, works on 9.6 - Mailing list pgsql-general

From Cory Tucker
Subject Re: Query Crashes PG 10.3 using partitions, works on 9.6
Date
Msg-id CAG_=8kDPWABX5o51Q53HvdWa6iWtA93sadk8Bb=Uk=jd_D0qSw@mail.gmail.com
Whole thread Raw
In response to Re: Query Crashes PG 10.3 using partitions, works on 9.6  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Query Crashes PG 10.3 using partitions, works on 9.6  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Can you extract a self-contained test case that uses unreasonable amounts
of memory?  It seems from this trace that the wheels are coming off in
at least two places, but identifying exactly where is impossible without
more info.

I will try to make a test case.  The data in this table is PII so I can't just export it, but I might be able to replicate using fake data.

Will try in the next few days and hopefully post back.

--Cory

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query Crashes PG 10.3 using partitions, works on 9.6
Next
From: Cory Tucker
Date:
Subject: Re: Query Crashes PG 10.3 using partitions, works on 9.6