| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | Laurent Hasson <ldh(at)laurent-hasson(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Big performance slowdown from 11.2 to 13.3 |
| Date: | 2021-07-21 19:15:28 |
| Message-ID: | 20210721191528.GC19620@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Jul 21, 2021 at 06:50:58PM +0000, ldh(at)laurent-hasson(dot)com wrote:
> The plans are pretty much identical too. I checked line by line and couldn't see anything much different (note that I have a view over this query). Here is the V13 version of the plan:
> I am out of my wits as to what is causing such a massive slowdown and how I could fix it.
>
> Any idea out there?
Could you send the "explain (analyze,buffers,settings) for query on the v11 and
v13 instances ?
Or a link to the execution plan pasted into explain.depesz.com.
It might be good to check using a copy of your data that there's no regression
between 11.2 and 11.12.
--
Justin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Lewis | 2021-07-21 22:12:16 | Re: Big performance slowdown from 11.2 to 13.3 |
| Previous Message | ldh@laurent-hasson.com | 2021-07-21 18:50:58 | Big performance slowdown from 11.2 to 13.3 |