Search Postgresql Archives

Re: Template for schema? (as opposed to databases)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Jan 11, 2022 at 5:38 PM Francisco Olarte <folarte@xxxxxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux