Request a Demo
Home   >   mailing lists

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

From Tom Lane
Subject Re: A serious change in performance between PG 15 and PG 16, 17, 18.
Date
Msg-id 1007982.1771214622@sss.pgh.pa.us
Whole thread Raw
In response to A serious change in performance between PG 15 and PG 16, 17, 18.  (Clive Boughton <clive.boughton@softimp.com.au>)
List pgsql-performance
Tree view 
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
hoursto 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

pgsql-performance by date:

Previous
From: Clive Boughton
Date:
Subject: A serious change in performance between PG 15 and PG 16, 17, 18.
Next
From: David Rowley
Date:
Subject: Re: A serious change in performance between PG 15 and PG 16, 17, 18.