From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
---|---|
To: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Template for schema? (as opposed to databases) |
Date: | 2022-01-11 16:50:02 |
Message-ID: | CAFCRh-8_iGhqU9Q30AFpTQkuk_yZKSPbHhUZ6Z1Erg8UyjxbeQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jan 11, 2022 at 5:38 PM Francisco Olarte <folarte(at)peoplecall(dot)com>
wrote:
> > Right now, that implies quite a few round-trips to the server, about
> 1'100, but on the LAN with sub-ms latency;
>
> How much sub-ms? I mean, I have 0.74 pings to my router, but this
> would be .82s, a good chunk of your quoted 2-3s, (and I'm not sure if
> libpq can do all queries in one RTT ).
>
Windows ping only says:
bytes=32 time<1ms TTL=64
But Linux ping does say:
icmp_seq=8 ttl=64 time=0.236 ms (I picked the worse one).
So even with 1K round-trips, that should account only for +/- 250ms (1/10th
the total). --DD
From | Date | Subject | |
---|---|---|---|
Next Message | Dominique Devienne | 2022-01-11 16:53:30 | Re: Template for schema? (as opposed to databases) |
Previous Message | Dominique Devienne | 2022-01-11 16:42:35 | Re: Template for schema? (as opposed to databases) |