Re: A serious change in performance between PG 15 and PG 16, 17, 18.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Clive Boughton <clive(dot)boughton(at)softimp(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: A serious change in performance between PG 15 and PG 16, 17, 18.
Date: 2026-02-16 04:03:42
Message-ID: 1007982.1771214622@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Clive Boughton <clive(dot)boughton(at)softimp(dot)com(dot)au> writes:
> When I recently upgraded to PG 18.1 (without any changes to the DB functions or tables, or indexing) it took 7-10 hours to produce the same result - a 300-600 times decrease in performance.

This complaint is completely un-actionable for lack of relevant
details. There are some hints here about describing performance
problems usefully:

https://wiki.postgresql.org/wiki/Slow_Query_Questions

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Rowley 2026-02-16 04:04:07 Re: A serious change in performance between PG 15 and PG 16, 17, 18.
Previous Message Clive Boughton 2026-02-16 03:49:02 A serious change in performance between PG 15 and PG 16, 17, 18.