Re: Postgresql 14 performance

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql 14 performance
Date: 2022-08-22 12:55:51
Message-ID: bec3b0ff-a0b9-f5d0-4ee7-8af167d04a51@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kenny Bachman 2022-08-22 13:17:02 Re: Postgresql 14 performance
Previous Message Jeff Janes 2022-08-22 06:16:31 Re: