pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away

Поиск
Список
Период
Сортировка
От Chris Withers
Тема pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away
Дата
Msg-id 55B26ED7.7010909@simplistix.co.uk
обсуждение исходный текст
Ответы Re: pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away  (Jan Lentfer <Jan.Lentfer@web.de>)
Список pgsql-general
Hi all,

I've been doing some lightweight load testing with
“pgbench -c8 -j8 -T10”

When run locally on the postgres server I've testing, this gives around
5000tps

When I do it from a server that has a 13ms ping latency, it drops to 37tps.

This is using the default pgbench script, is it to be expected?
If so, why?

cheers,

Chris


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Using the database to validate data
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Using the database to validate data