Re: Query Crashes PG 10.3 using partitions, works on 9.6

From: Cory Tucker <cory(dot)tucker(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query Crashes PG 10.3 using partitions, works on 9.6
Date: 2018-03-28 22:16:33
Message-ID: CAG_=8kDPWABX5o51Q53HvdWa6iWtA93sadk8Bb=Uk=jd_D0qSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cory Tucker 2018-03-28 22:18:47 Re: Query Crashes PG 10.3 using partitions, works on 9.6
Previous Message Tom Lane 2018-03-28 22:10:48 Re: Query Crashes PG 10.3 using partitions, works on 9.6