Re: 8.3 write performance
От | Enrico Sirola |
---|---|
Тема | Re: 8.3 write performance |
Дата | |
Msg-id | 4FDAF452-E6CD-46CA-96DA-8674E496C5D4@gmail.com обсуждение исходный текст |
Ответ на | 8.3 write performance (Enrico Sirola <enrico.sirola@gmail.com>) |
Список | pgsql-performance |
Hi, I follow up myself: I was using pgbench with the wrong scale size. With the configuration I posted before and scale=100 I Get the following: sudo -u postgres pgbench -c 10 -t 10000 -s 100 starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 10 number of transactions per client: 10000 number of transactions actually processed: 100000/100000 tps = 4399.753895 (including connections establishing) tps = 4405.228901 (excluding connections establishing) sudo -u postgres pgbench -c 50 -t 10000 -s 100 starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 50 number of transactions per client: 10000 number of transactions actually processed: 500000/500000 tps = 3208.532479 (including connections establishing) tps = 3211.816174 (excluding connections establishing) which I think is in line with the expectations. Thanks, e.
В списке pgsql-performance по дате отправления: