Horton
Menu

Re: PostgreSQL 15-->18 slowdown?

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Israel Brewster <ijbrewster@alaska.edu>
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2026-06-26T18:40:09Z
Lists: pgsql-general 

On 6/26/26 11:19 AM, Israel Brewster wrote:
> On Jun 26, 2026, at 10:14 AM, Adrian Klaver <adrian.klaver@aklaver.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
>>
>