| From: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgresql 14 performance |
| Date: | 2022-08-27 16:04:16 |
| Message-ID: | d0abdd47-97f9-4f82-9759-2fe3309784d1@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Christian | 2022-08-27 17:02:23 | could not connect to server, in order to operate pgAdmin/PostgreSQL via python |
| Previous Message | Jeff Janes | 2022-08-27 15:49:13 | Re: Postgresql 14 performance |