On Mon, 2023-10-30 at 08:59 -0700, David Ventimiglia wrote:
> On Mon, Oct 30, 2023 at 8:46 AM Laurenz Albe wrote:
> > On Mon, 2023-10-30 at 08:05 -0700, David Ventimiglia wrote:
> > > Can someone help me develop a good mental model for estimating PostgreSQL
> > > throughput?
> > > Here's what I m
Thanks! Let's say there are 10 cores, the workload is not CPU bound, and
there is a connection pooler like pgBouncer in place. Would the number of
operations more likely be:
- 1000 ms / total ms per operation * number of cores = 1000 ms / 101 ms
* 10 = ~100
- 1000 ms / total ms per oper
On Mon, 2023-10-30 at 08:05 -0700, David Ventimiglia wrote:
> 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
>
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 oper
