Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server

From: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
To: Sergio Rus <geiros(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server
Date: 2023-05-31 18:16:40
Message-ID: CAEudQArdAfF3AhLmJQR=ar9Y0kmzCcv=jmv-_B07CUrxJQ+M7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Em qua., 31 de mai. de 2023 às 09:40, Sergio Rus <geiros(at)gmail(dot)com>
escreveu:

> As you can see, server B has 2 CPUs and is using NUMA on Linux. And the
> CPU clock is slower on server B than server A. Maybe any of those are
> causing that latency?
>
> Any suggestions or ideas where to look? I'd really appreciate your help.
>
If this is cpu bound, linux perf can show the difference.
https://wiki.postgresql.org/wiki/Profiling_with_perf

regards,
Ranier Vilela

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message James Pang (chaolpan) 2023-06-01 03:36:13 thousands of CachedPlan entry per backend
Previous Message Andres Freund 2023-05-31 17:54:23 Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server