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

[Ranier Vilela <ranier.vf@xxxxxxxxx>]

Em qua., 31 de mai. de 2023 às 09:40, Sergio Rus <geiros@xxxxxxxxx> 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