postgresql11.1 - stabilize partition pruning at execution time

[Aliza Abulafia <Aliza.Abulafia@xxxxxxxxxx>]

Subject: postgresql11.1 - stabilize partition pruning at execution time

 

Hi,

 

we are evaluating postgresql11.1 for our productions, trying to use partitions to ease vacuum work,
(we have a system with 4251 updates per second, ~1000 delete per second and ~3221 inserts per second and 1billion transaction per day). we face a problem, that partition pruning is not working steadily with updates although we have: 1) part_key=value at our “where” clause 2) enable_partition_pruning = 'on'. we understood that there is a new patch at 11, that is supposed to support ( Faster Partition Pruning + Partition Pruning at Execution Time)

how can we stable partition pruning?, how to identify the reason when it does not work? what parameters affect it? appreciate if someone has experience with this.

 

thanks in advance, Aliza.

 

This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service