Postgres Pro
Downloads
Home   >   mailing lists

RE: Performance of the partitioning in the large scale - Mailing list pgsql-hackers

From Kato, Sho
Subject RE: Performance of the partitioning in the large scale
Date
Msg-id 25C1C6B2E7BE044889E4FE8643A58BA963B259B7@G01JPEXMBKW03
Whole thread Raw
In response to Re: Performance of the partitioning in the large scale  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Friday, September 28, 2018 6:03 AM, David Rowley < david.rowley@2ndquadrant.com> wrote:
> I think instead of attempting to highlight other bottlenecks, it might
> be better to focus on lending a hand reviewing and testing the existing
> set of patches. 

Thanks for your reply. Ok, I focus on reviewing and testing the existing set of patches.

> Unless you're running with plan_cache_mode =
> 'force_generic_plan' then the overhead of the partitioned cases likely
> includes planning too.

I'm running with plan_cache_mode = auto. I'll check cached plan is used.

Thanks,
--
Sho Kato

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Pluggable Storage - Andres's take
Next
From: Michael Paquier
Date:
Subject: Re: heap_sync seems rather oblivious to partitioned tables(wal_level=minimal)