Hi, Le 09/07/2018 à 22:10, David Rowley a écrit : > On 10 July 2018 at 00:47, Christophe Courtois > <christophe.court...@dalibo.com> wrote: > (Christophe reports 2x performance regression with PG11 when using > 10000 partitions) > Thanks for the report. Can you supply your test case when shows this > regression? > Please, can you also post in English for the future.
Sorry, that was supposed to be a private mail to Thomas. I lack time to reproduce cleanly my tests after the latest patch and dig a bit myself. Basically I do an inner join between a 10'000 partitions table and itself with a simple WHERE. I'm not sure that this happens in the real world. Yours, -- Christophe Courtois Consultant Dalibo http://dalibo.com/ - http://dalibo.org/