public inbox for [email protected]
help / color / mirror / Atom feedFrom: Israel Brewster <[email protected]>
To: Tom Lane <[email protected]>
Cc: Ruben Morais <[email protected]>
Cc: PostgreSQL General <[email protected]>
Subject: Re: PostgreSQL 15-->18 slowdown?
Date: Fri, 26 Jun 2026 10:58:09 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<CAG8sLzuG6wwUR3XmMDQtvUWk3DCQNL2Zq-OLCx_PnOarskbUdg@mail.gmail.com>
<[email protected]>
<[email protected]>
> On Jun 26, 2026, at 10:44 AM, Tom Lane <[email protected]> wrote:
>
> Israel Brewster <[email protected]> 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
view thread (10+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: PostgreSQL 15-->18 slowdown?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox