Re: Horizontal scalability/sharding

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pavan(dot)deolasee(at)gmail(dot)com
Cc: obartunov(at)gmail(dot)com, robertmhaas(at)gmail(dot)com, josh(at)agliodbs(dot)com, masonlists(at)gmail(dot)com, simon(at)2ndquadrant(dot)com, bruce(at)momjian(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Horizontal scalability/sharding
Date: 2015-09-03 05:42:02
Message-ID: 20150903.144202.999966130688607662.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>> One lesson from XL we got is that we need testing framework for cluster,
>> so any cluster project should at least pass functional and performance
>> testing.
>>
>
> +1. In early XC days, we focused a lot on adding newer features and
> supporting as many PG features as possible. That took its toll on the
> testing and QA. It was a mistake though my feeling was we tried to correct
> that to some extend with XL. We did a 9.5 merge, which of course was a big
> deal, but other than more time is being spent on improving stability and
> performance

Agreed. Any cluster project needs a cluster testing framework.

pgpool-II project runs "build farm" which runs cluster regression
tests every day. The tests includes several versions of pgpool-II and
PostgreSQL combinations using docker. Still it needs more tests but
even with limited test cases, it is pretty usefull to detect bugs.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2015-09-03 06:25:00 pg_ctl/pg_rewind tests vs. slow AIX buildfarm members
Previous Message Pavan Deolasee 2015-09-03 05:31:57 Re: Horizontal scalability/sharding