| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Cory Tucker <cory(dot)tucker(at)gmail(dot)com> |
| 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:19:13 |
| Message-ID: | 25711.1522275553@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Cory Tucker <cory(dot)tucker(at)gmail(dot)com> writes:
>> 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.
My guess is that the specific data is not critical at all, just the
table properties. You might need to take care that the same EXPLAIN
plan is selected, which might require fake data that has roughly
similar properties as to number of distinct values and so on.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Beck | 2018-03-28 22:45:06 | Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade |
| Previous Message | Cory Tucker | 2018-03-28 22:18:47 | Re: Query Crashes PG 10.3 using partitions, works on 9.6 |