Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wdBTM-003wb5-36 for pgsql-general@arkaria.postgresql.org; Fri, 26 Jun 2026 18:40:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wdBTL-00CNaA-1F for pgsql-general@arkaria.postgresql.org; Fri, 26 Jun 2026 18:40:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wdBTL-00CNZz-0C for pgsql-general@lists.postgresql.org; Fri, 26 Jun 2026 18:40:15 +0000 Received: from fhigh-b2-smtp.messagingengine.com ([202.12.124.153]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wdBTI-00000000NE7-3s12 for pgsql-general@lists.postgresql.org; Fri, 26 Jun 2026 18:40:14 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfhigh.stl.internal (Postfix) with ESMTP id B7CDA7A015C; Fri, 26 Jun 2026 14:40:11 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Fri, 26 Jun 2026 14:40:11 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1782499211; x=1782585611; bh=VziaWLADudtMgVeE4tMrTHc5S6x8x+iuy6Ttvqq/JmM=; b= g1GXymUu6od03DFD4kvY8s4XWA74HyADJcV0WraUkqlZfPECHiJGyAxSPH9RADKc jJTGIIE7GKmofvTOlgl4tqFQt0cR0jm9Mrh5sKvNLXc5IBsk1So/0m86TgIDj5iS HcmeEQtl4lhTWxKAEML2DZudd9fPHNrjccK7+8jbb21xwDHHK/4eI9hjceMWw6Eb R4p6s5TLviIEsG8XjCgODn3gdGC4EO5yXuCBViKhCkVwgrJCQ+2prME6EibBGLkw +R+gocThjoCnk3WITHWz+dbe8e7jqVMHAmnsyQgo9MlBm2RdAbVvESNmAFCS0jXl NXzfjyk0+xR3AL7hJbpj4Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1782499211; x= 1782585611; bh=VziaWLADudtMgVeE4tMrTHc5S6x8x+iuy6Ttvqq/JmM=; b=k bmmoTd/rUdAJaatxfj8FrANNyj/jiw9L+r20k0tBAas5V+MAt8QRkWlLtS2iD3jQ iZbsMGm9iatNWUxCTEBqPGpaPK5ixinXbAVKBPy7C6toRSQ62E6PRjj5qA7+7OMi 3DxS+wH8c28J63FBbjrgnUW1DSBQmi63fYHEX3uSD0ApZoYhTQs7OsrIq1FqQStd LyV3Az1cSu/+S3zYMsxpBXy7b9XRtEPZ1SW0UDW1is1OTrBCT/NLVTshG1Iepm7I EbSb6yr5wt8w0QvUsrJ+IbLBS6BbYd2Ojb/HYfT5dkE8gnfpDiid1i/y73AqJaK6 GYV6pYrTceUx1e/EQZa1A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTGEzfKNNAeUeBtJ6yD/gAWYoEeIBxgspoSBZzXdsK2z0AX1qR1r1zyFcTseQHURrJ Pxef5Ih50SKQJDVEID30z/I8jPFCxbdTzd7MgEbgpVBAoEXBALlYWIp/VV9IowL8j//Gfs dpYnEQxoslfS7zImqQUj+ECCzdcKgnVNTMkGRHX9qR7NmzrV6gyEte5prSgdAMzkojw8Qx 92/nTWyee93ZmNYllA063niQTbgYunfMqvx2iCnB3/skvxDVQ7wBB3x4UhqtoXNiFPQgba oz6JcGqUQqU6Xm+KLKxVnVhFIjCBdPt04LfYh0DdFX0aHs0/C7UGkopJRWxBud6bzg8rTp jqL7yPGRyenXziwSywea1O3ClfM4QltVtZblgye5cPLxRDQrNbNKdW5d22NsvkojWirkFF 3G1J53ZinM8ryg48hZ/s+Iu83iw9XNW2w09fjavgoWqeEm7/PS8Bzu1Gt/YE0F4yfa8EL2 X4XYKgsfjyNpiyk0ZIbhVRNKvPgeIq0KaUOMJWwig/orZ/2AQk7Gmbfg8WxQt+CYHXy1DF QOdJ2JJ0lzfuCd6BfNqecoDw6e/+t4bGnBQ/HbHvMNhlIHEqC3OOrUQjciPsJI4mlRNoZt /HYuVkv7FPz7XqhiKhoPcRiRrYDysbef98NGB6PC1hOAHbDlzV9RGI5btYyg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 26 Jun 2026 14:40:10 -0400 (EDT) Message-ID: <13dd73fa-7cfc-417c-9b16-5c16142a2058@aklaver.com> Date: Fri, 26 Jun 2026 11:40:09 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: PostgreSQL 15-->18 slowdown? To: Israel Brewster Cc: PostgreSQL General References: <4A6D9280-1409-42A8-9A1F-99E2A558E2BB@alaska.edu> <2ce465f0-f7f3-4c6a-9f68-b53439416336@aklaver.com> <9FB992C2-0A1D-4BFE-8066-77F130471B9B@alaska.edu> Content-Language: en-US From: Adrian Klaver In-Reply-To: <9FB992C2-0A1D-4BFE-8066-77F130471B9B@alaska.edu> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/26/26 11:19 AM, Israel Brewster wrote: > On Jun 26, 2026, at 10:14 AM, Adrian Klaver > 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 >> >