Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 14 performance - Mailing list pgsql-admin

From Mladen Gogala
Subject Re: Postgresql 14 performance
Date
Msg-id d8df81e2-c844-d7f5-f1e6-7c050ecaa4c2@gmail.com
Whole thread Raw
In response to Re: Postgresql 14 performance  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Postgresql 14 performance  (Mladen Gogala <gogala.mladen@gmail.com>)
Re: Postgresql 14 performance  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-admin
Tree view
On 8/21/22 20:46, Jeff Janes wrote:

You can see there that little time was spent reading data, so that explains why repeating the query didn't make it much faster due to caching.  The time isn't spent reading data, but doing CPU work on data already in memory.

Cheers,

Jeff

Agreed. The "perf top" output produced by Kenny definitely indicates that. That's precisely why I concentrated on JIT. Anything else would give us a slim chance of increasing the query speed.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

pgsql-admin by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Postgresql 14 performance
Next
From: Jeff Janes
Date:
Subject: Re: