Postgres Pro
Downloads
Home   >   mailing lists

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_=8kCHM8h0UVjDGa1BODNmhTBRF_utugJDhQ=+FyoHrYRM=w@mail.gmail.com
Whole thread Raw
In response to RE: Query Crashes PG 10.3 using partitions, works on 9.6  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
List pgsql-general
Tree view


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.
 

pgsql-general by date:

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