Postgres Pro
Downloads
Home   >   mailing lists

RE: speeding up planning with partitions - Mailing list pgsql-hackers

From Imai, Yoshikazu
Subject RE: speeding up planning with partitions
Date
Msg-id 0F97FA9ABBDBE54F91744A9B37151A512784F5@g01jpexmbkw24
Whole thread Raw
In response to RE: speeding up planning with partitions  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Responses Re: speeding up planning with partitions
RE: speeding up planning with partitions
List pgsql-hackers
Tree view 
Tsunakawa-san,

On Wed, Feb 6, 2019 at 2:04 AM, Tsunakawa, Takayuki wrote:
> Can you compare the performance of auto and force_custom_plan again with
> the attached patch?  It uses PGPROC's LOCALLOCK list instead of the hash
> table.

Thanks for the patch, but it seems to have some problems.
When I executed create/drop/select commands to large partitions, like over than 512 partitions, backend died
unexpectedly.Since I could see the difference of the performance of auto and force_custom_plan when partitions is
large,patch needs to be modified to check whether performance is improved or not.
 

Thanks
--
Yoshikazu Imai

pgsql-hackers by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: Transaction commits VS Transaction commits (with parallel) VSquery mean time
Next
From: David Rowley
Date:
Subject: Re: speeding up planning with partitions