Re: Performance regression with PostgreSQL 11 and partitioning - Mailing list pgsql-hackers

From Christophe Courtois
Subject Re: Performance regression with PostgreSQL 11 and partitioning
Date
Msg-id 11e9b5a5-6791-eb17-34ca-6e76c0bd3572@dalibo.com
Whole thread Raw
In response to Re: Un peu décu : Re: Performance regression with PostgreSQL 11 and partitioning  (David Rowley <david.rowley@2ndquadrant.com>)
List 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/


pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Let's remove DSM_IMPL_NONE.
Next
From: "Jamison, Kirk"
Date:
Subject: Recovery performance of standby for multiple concurrent truncateson large tables