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 bec3b0ff-a0b9-f5d0-4ee7-8af167d04a51@gmail.com
Whole thread Raw
In response to Re: Postgresql 14 performance  (Mladen Gogala <gogala.mladen@gmail.com>)
Responses Re: Postgresql 14 performance  (Kenny Bachman <kenny.bachman17@gmail.com>)
List pgsql-admin
Tree view
On 8/21/22 21:16, Mladen Gogala wrote:

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.

When I come to think of it, are you using huge pages for shared buffers? Huge pages tend to decrease page tables and lessen the impact of paging.

Regards

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

pgsql-admin by date:

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