Help with a good mental model for estimating PostgreSQL throughput

Поиск
Список
Период
Сортировка
От David Ventimiglia
Тема Help with a good mental model for estimating PostgreSQL throughput
Дата
Msg-id CADE7j6jZxjcDvw6PEN5aVrm27eq30f2obZu=0psbgdFL9gc7Gw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Help with a good mental model for estimating PostgreSQL throughput
Список pgsql-general
Дерево обсуждения
Hello!

Can someone help me develop a good mental model for estimating PostgreSQL throughput?  Here's what I mean.  Suppose I have:
  • 1000 connections
  • typical query execution time of 1ms
  • but additional network latency of 100ms
What if at all would be an estimate of the number of operations that can be performed within 1 second?  My initial guess would be ~10000, but then perhaps I'm overlooking something.  I expect a more reliable figure would be obtained through testing, but I'm looking for an a priori back-of-the-envelope estimate.  Thanks!

Best,
David

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

Предыдущее
От: Alexander Kukushkin
Дата:
Сообщение: Re: pg_checksums?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Help with a good mental model for estimating PostgreSQL throughput