incorrect pgbench results when postgres fails

Поиск
Список
Период
Сортировка
От Ahmed Bessifi
Тема incorrect pgbench results when postgres fails
Дата
Msg-id CAJJHcgQCrx9=RU7agXT4-Cw66j0DWzFgBfM9pXiKBdRTGdxG3Q@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi,

I recently used pgbench to start some perf tests with pgpool and two postgres servers set up in master/slave mode.
In fact, during a benchmark (with pgbench) I stopped the slave (test failover) node and here the test finish quickly (not as expected) and I get a faulty 'tps' results :
(Bad result)
tps = 202.508908 (including connections establishing)
tps = 210.639230 (excluding connections establishing)
Instead of :
(Good result)
tps = 55.020587 (including connections establishing)
tps = 55.044625 (excluding connections establishing)

I think
this is
a bug
, and I want just inform you about it and see if it could be reported.

Best regards,
Ahmed


--
"We build software for people who build software.."
--
Ahmed Bessifi

--
DevOps Engineer in IMDEV
Engineer degree in computer science from FST since 2013
Degree in system and network administration from IsetCom since 2010
Member in CLLFST club.
Member in open vSwitch community

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Little, Doug"
Дата:
Сообщение: hiding encrypt/decrypt password
Следующее
От: Bernhard Schrader
Дата:
Сообщение: clog problems after dump/restore