Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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.
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux