Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Clive Boughton <clive.boughton@softimp.com.au>
Cc: pgsql-performance@postgresql.org
Date: 2026-02-16T04:03:42Z
Lists: pgsql-performance 
Clive Boughton <clive.boughton@softimp.com.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