pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Mladen Gogala <gogala.mladen@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Postgresql 14 performance
Date: Sat, 27 Aug 2022 12:04:16 -0400
Message-ID: <d0abdd47-97f9-4f82-9759-2fe3309784d1@gmail.com> (raw)
In-Reply-To: <CAMkU=1xWJpZYk_mXp=Sc2upNOCcbr-oGg=N41DjktLYs5iW7Gg@mail.gmail.com>
References: <CAC0w7LL+uFgPvctiHMxrVZV-DnNVg2K_wFaeZwM96XQFkjk1uA@mail.gmail.com>
	<CAMkU=1yomYgYxMx8nwXUAv1+iM5aJTuqW+Qo3Qz6nGaFbGwSFA@mail.gmail.com>
	<CAC0w7LLghXX+kmkqWAP0-UyanqNCVaWkbtbrZ7yqzX4CoM6i0A@mail.gmail.com>
	<CAMkU=1y30sj8rWcgDoJb4PF0Xb4_N_nv8dppd-xZO3d1CGVZqQ@mail.gmail.com>
	<d8df81e2-c844-d7f5-f1e6-7c050ecaa4c2@gmail.com>
	<CAMkU=1xWJpZYk_mXp=Sc2upNOCcbr-oGg=N41DjktLYs5iW7Gg@mail.gmail.com>

On 8/27/22 11:49, Jeff Janes wrote:
> I don't think that that follows at all. Proper index usage can vastly 
> improve CPU-bound performance, not just Disk-bound performance. And 
> that it used to be faster in the recent past suggests that it is 
> certainly possible for it to be faster.
>
> I assume he is on a system/installation without a JIT provider, so 
> even if jit is enabled in the postgresql.conf, it won't be used.

That may also be true. The plan attached by the OP doesn't have any JIT 
information despite him telling us that JIT is turned on. As for the 
proper index usage, I would need to look at the plan details, in 
particular, how many rows were retrieved in each index range scan step. 
Unfortunately, I don't have time to do that.

Regards

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

view thread (20+ messages)

Message-ID: <d0abdd47-97f9-4f82-9759-2fe3309784d1@gmail.com>
Permalink:  ../d0abdd47-97f9-4f82-9759-2fe3309784d1@gmail.com/
Also on:    postgresql.org/message-id/d0abdd47-97f9-4f82-9759-2fe3309784d1@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gogala.mladen@gmail.com, jeff.janes@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Postgresql 14 performance
  In-Reply-To: <d0abdd47-97f9-4f82-9759-2fe3309784d1@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox