Re: [PERFORM] why after increase the hash table partitions, tpmc decrease

2014-09-02 Thread Takashi Horikawa
lto:pgsql-performance-ow...@postgresql.org] On Behalf Of Xiaoyulei > Sent: Tuesday, September 02, 2014 4:00 PM > To: pgsql-performance@postgresql.org > Cc: yetao > Subject: [PERFORM] why after increase the hash table partitions, tpmc > decrease > > > > We use ben

[PERFORM] why after increase the hash table partitions, tpmc decrease

2014-09-02 Thread Xiaoyulei
We use benchmarksql to start tpcc test in postgresql 9.3.3. Before test we set benchmarksql client number about 800. And we increase the hash partitions from 16 to 1024 , in order to reduce the hash partition locks competition. We expect that after increase the number of partitions, reduces lock