8rc2 & BLCKSZ
От | Pailloncy Jean-Gerard |
---|---|
Тема | 8rc2 & BLCKSZ |
Дата | |
Msg-id | FB7893AB-5436-11D9-9A44-000A95DE2550@rilk.com обсуждение исходный текст |
Список | pgsql-performance |
Hi, A small test with 8rc2 and BLCKSZ of 8k and 32k. It seems there is a 10% increase in the number of transactions by second. Does someone plan to carefully test the impact of BLCKSZ ? Cordialement, Jean-Gérard Pailloncy with 8k: > /test/bin/pgbench -c 10 -t 300 test starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 10 number of clients: 10 number of transactions per client: 300 number of transactions actually processed: 3000/3000 ... tps = 26.662146 (excluding connections establishing) tps = 23.742071 (excluding connections establishing) tps = 28.323828 (excluding connections establishing) tps = 27.944931 (excluding connections establishing) tps = 25.898393 (excluding connections establishing) tps = 26.727316 (excluding connections establishing) tps = 27.499692 (excluding connections establishing) tps = 25.430853 (excluding connections establishing) with 32k: > /test/bin/pgbench -c 10 -t 300 test starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 10 number of clients: 10 number of transactions per client: 300 number of transactions actually processed: 3000/3000 ... tps = 28.609049 (excluding connections establishing) tps = 29.978503 (excluding connections establishing) tps = 30.502606 (excluding connections establishing) tps = 33.406386 (excluding connections establishing) tps = 30.422134 (excluding connections establishing) tps = 26.878762 (excluding connections establishing) tps = 31.461116 (excluding connections establishing)
В списке pgsql-performance по дате отправления: