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

From: Cory Tucker <cory(dot)tucker(at)gmail(dot)com>
To: "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(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:18:47
Message-ID: CAG_=8kCHM8h0UVjDGa1BODNmhTBRF_utugJDhQ=+FyoHrYRM=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> You are running the query (DELETE statement) as if the table is not
> partitioned which is causing the server to crash.
>
> Please run that query for each partitions separately in a loop with
> dynamic query and you should see the improvement. It should be pretty quick.
>
>

I understand that I can do that and it would be quicker. But the point of
the email was that this thing that works on 9.6, and is valid SQL, causes
the server to crash in a newer version using a valid supported
configuration.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-03-28 22:19:13 Re: Query Crashes PG 10.3 using partitions, works on 9.6
Previous Message Cory Tucker 2018-03-28 22:16:33 Re: Query Crashes PG 10.3 using partitions, works on 9.6