RE: How to make partitioning scale better for larger numbers ofpartitions

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема RE: How to make partitioning scale better for larger numbers ofpartitions
Дата
Msg-id 0A3221C70F24FB45833433255569204D1FA5091E@G01JPEXMBYT05
обсуждение исходный текст
Ответ на RE: How to make partitioning scale better for larger numbers ofpartitions  ("Kato, Sho" <kato-sho@jp.fujitsu.com>)
Ответы RE: How to make partitioning scale better for larger numbers ofpartitions
Список pgsql-hackers
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 по дате отправления: