Re: PostgreSQL 15-->18 slowdown?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Israel Brewster <ijbrewster(at)alaska(dot)edu>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL 15-->18 slowdown?
Date: 2026-06-26 18:40:09
Message-ID: 13dd73fa-7cfc-417c-9b16-5c16142a2058@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/26/26 11:19 AM, Israel Brewster wrote:
> On Jun 26, 2026, at 10:14 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>>

>> This one does not show the actual query.
>
> Right, sorry. It’s the same query as in the first one though. Only
> difference is sequence scan off.

What are the definitions for orientation_station_idx and
new_data_station_idx?

What are the data types for the columns they are pointing at?

>>> ---
>>> 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
>>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2026-06-26 18:44:25 Re: PostgreSQL 15-->18 slowdown?
Previous Message Israel Brewster 2026-06-26 18:19:06 Re: PostgreSQL 15-->18 slowdown?