Postgres Pro
Downloads
Home   >   mailing lists

RE: How to make partitioning scale better for larger numbers ofpartitions - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: How to make partitioning scale better for larger numbers ofpartitions
Date
Msg-id 0A3221C70F24FB45833433255569204D1FA5091E@G01JPEXMBYT05
Whole thread Raw
In response to RE: How to make partitioning scale better for larger numbers ofpartitions  ("Kato, Sho" <kato-sho@jp.fujitsu.com>)
Responses RE: How to make partitioning scale better for larger numbers ofpartitions  ("Kato, Sho" <kato-sho@jp.fujitsu.com>)
List pgsql-hackers
Tree view 
From: Kato, Sho [mailto:kato-sho@jp.fujitsu.com]
> I did pgbench -M prepared and perf record.
> 
> UPDATE latency in prepared mode is 95% shorter than in simple mode.
> SELECT latency in prepared mode is 54% shorter than in simple mode.
> INSERT latency in prepared mode is 8% shorter than in simple mode.

Thanks.  And what does the comparison look like between the unpartitioned case and various partition counts?  What's
theperformance characteristics in terms of the latency and partition count?   I thought that's what you tried to reveal
first?

Regards
Takayuki Tsunakawa

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: patch to allow disable of WAL recycling
Next
From: David Rowley
Date:
Subject: Re: Internal error XX000 with enable_partition_pruning=on, pg 11beta1 on Debian