Re: PostgreSQL 15-->18 slowdown?

> On Jun 26, 2026, at 10:44 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> Israel Brewster <ijbrewster@alaska.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