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

Thanks for your replies, you were totally right, it was due to the CPU governor: the governor was set to 'powersave'. I've changed it to 'performance' and the server is flying now. I'm still working on it, but the first quick tests I've made are showing much better numbers. Those simple short queri

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

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

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

Hi, On 2023-05-31 14:40:05 +0200, Sergio Rus wrote: > I've been configuring a new server and tuning Postgresql 15.3, but I'm > struggling with a latency I'm consistently seeing with this new server when > running fast short queries, compared to the other server. > > We're running two different ve

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

> Server B is the new server and is way more powerful than server A: > ... > So after all, the CPU clock speed still counts these days! Hi Sergio, Maybe "powerful" + "powersave"? as I see Sever B : Processor Base Frequency : 2.40 GHz AND * Max Turbo Frequency : 3.90 GHz* Could you verify t

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

Thanks for your reply, Ken. With such a big server I was convinced that we should see a boost everywhere, but after spending so much time tweaking and looking at so many parameters on Linux, Postgresql and our current setup, I started to think that maybe that latency was intrinsic to the hardware

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

On Wed, May 31, 2023 at 02:40:05PM +0200, Sergio Rus wrote: > Hi guys, > > I've been configuring a new server and tuning Postgresql 15.3, but I'm > struggling with a latency I'm consistently seeing with this new server when > running fast short queries, compared to the other server. > > We're run

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

Hi guys, I've been configuring a new server and tuning Postgresql 15.3, but I'm struggling with a latency I'm consistently seeing with this new server when running fast short queries, compared to the other server. We're running two different versions of Postgresql: - Server A: Postgresql 9.3 - S