Horton

Re: Performance regression with PostgreSQL 11 and partitioning

Christophe Courtois <christophe.courtois@dalibo.com>

View thread View on postgr.es
From: Christophe Courtois <christophe.courtois@dalibo.com>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Thomas Reiss <thomas.reiss@dalibo.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2018-07-10T06:57:30Z
Lists: pgsql-hackers 
Hi,

Le 09/07/2018 à 22:10, David Rowley a écrit :
> On 10 July 2018 at 00:47, Christophe Courtois
> <christophe.courtois@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/

Commits

  1. Fix typo in comment

  2. Allow direct lookups of AppendRelInfo by child relid

  3. Teach adjust_appendrel_attrs(_multilevel) to do multiple translations.