Re: PostgreSQL 15-->18 slowdown?

> On Jun 26, 2026, at 10:44 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Israel Brewster <ijbrewster(at)alaska(dot)edu> writes:
>
>> SubPlan 1
>> -> Limit (cost=0.00..0.48 rows=1 width=1)
>> -> Nested Loop (cost=0.00..13833793.79 rows=29105774 width=1)
>> -> Seq Scan on tilt_data (cost=0.00..13469970.40 rows=29105774 width=16)
>> Filter: (station = stations.id)
>> -> Materialize (cost=0.00..1.22 rows=1 width=16)
>> -> Seq Scan on tilt_orientation (cost=0.00..1.21 rows=1 width=16)
>> Filter: (station = stations.id)
>
> Can you show us the EXPLAIN output for this part of the plan in v15?

I wish I could - I was wanting to see that myself. Unfortunately, I upgraded to 18 using —link, so by the time I discovered this issue, I had no way to go back to 15 (other than restoring from backups or the like), at least to the best of my knowledge.

---
Israel Brewster
Software Engineer
Alaska Volcano Observatory
Geophysical Institute - UAF
2156 Koyukuk Drive
Fairbanks AK 99775-7320
Work: 907-474-5172
cell: 907-328-9145

>
> regards, tom lane