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

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

In response to

Browse pgsql-general by date

  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)