| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: regression in PG 15.1 |
| Date: | 2022-11-29 04:55:22 |
| Message-ID: | B6025887-D73F-4B5B-9925-4DA4B675F7E5@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
OK, this is not a regression, but a combination of things:
- in 14, it is searching all partitions, but is fast enough that I never noticed (log_min_duration is 1s)
- in 15, at first try it took 30s for JIT, oops
- with that turned off, performance was still really bad
- statistics were not properly updated after the upgrade to 15
- and a big jump was made in a monotonically increasing serial being searched on
- instead of 142 index scans, 141 returning 0, and 1 returning a few rows, we got 142 seq scans
- problem fixed itself while I was still figuring it all out, because of normal vacuum thresholds
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Viljo Hakala | 2022-11-29 08:47:13 | Logical replication halted due to "this slot has been invalidated because it exceeded the maximum reserved size." |
| Previous Message | Gary Kelley | 2022-11-29 02:04:10 |