Date: Tue, 21 Feb 2023 11:35:54 -0500
From: Stephen Frost <sfrost@snowman.net>
To: Charles <peacech@gmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>, Jeff Janes <jeff.janes@gmail.com>,
	pgsql-bugs@lists.postgresql.org
Subject: Re: Query run in 27s with 15.2 vs 37ms with 14.6
Message-ID: <Y/Ty6roAf76C6Pzw@tamriel.snowman.net>
References: 
 <CABthHP8Maot3JBq6jMfcrW0Y2xPftnQsi=2qCPQ=SkKbqnkt6g@mail.gmail.com>
 <CAMkU=1xDZnL_=2BrMnOd2FgZ62G=qqhFD+ZtxC-74Mnu-qOPuQ@mail.gmail.com>
 <CABthHP84n1-aM5CV5RLJt2L9+9QG7Zp2EHsHf8tqHS04qASqrw@mail.gmail.com>
 <CAApHDvodhLNtvg+2CFLDWMEHg97n248B0WcN1WHN+uH2WomSjA@mail.gmail.com>
 <CABthHP-XJXF8L_GLnWvU6Mm09B3_gJV8fy1uAPOFhLrAOPopLg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="Uezjde4l4xS/mbfY"
Content-Disposition: inline
In-Reply-To: 
 <CABthHP-XJXF8L_GLnWvU6Mm09B3_gJV8fy1uAPOFhLrAOPopLg@mail.gmail.com>
User-Agent: Mutt/2.1.4 (2021-12-11)
Archived-At: 
 <https://www.postgresql.org/message-id/Y/Ty6roAf76C6Pzw%40tamriel.snowman.net>
Precedence: bulk


--Uezjde4l4xS/mbfY
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Greetings,

* Charles (peacech@gmail.com) wrote:
> Thank you for the hint. I think this is it. random_page_cost was set to 1.1
> in 14.6 (the data directory is located in a ssd). When upgrading to 15.2 I
> thought that ssd random seek time is not that close to sequential seek
> time, so I revert it back to 4.

In the future, you might want to be sure and include 'settings' in your
EXPLAIN options, eg:

EXPLAIN (ANALYZE, BUFFERS, SETTINGS) query ...

so that you see what non-default planner settings are set when the query
is being planned.

Thanks,

Stephen

--Uezjde4l4xS/mbfY
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmP08uYACgkQ7WyKOINH
ZFXYjhAAktnhJYxeKx3iFPNbsigHph9BGIHfYyO/VDbldj8YqNF3Iw4Vq76G5tWW
9k/+fuoBbGn23UWDLiErRCIGJ2QuCG6SCWYXGMx6llOODU346AbtefFcsGCt/l2G
LuDevE9phUSoJQ/MWcDFgTOowrOAWCy3My/GvrDFI7aHcABgu6L7Iws5bQLNRHYf
cX5zWEinwlkb2357/IH1z7y/u/OjsHBhftcX+copv5gpjfQhvAvFue9ZhgV3zgFB
5RFT5HjWsGHBjwGWhovDFyJgSuag2NPkJPomwVzcGEkmS2AbDKjN2adWH2zzRvX9
dq0OQeJk2aF8pmWGNd+FUdhom9FnqJSeyyxce1s9xD2FWTMMtpMKcJHebO0QZHwU
t39yMTRXa5vBPu1d5BYNLak93GbD2JYF4we55LgYxlwKn8dlXU8PRo9RjQtzFEzO
8pGWQCz9JffBrEj7fIZJ2XdQK6Sj1Nkl0jrjRB3GKUSDcxh8wvFS5BtPC/JVyIju
nQaV0KpoyLvi9QiCzPo8XvwNY1JUqawo6SEyNk/w8ydiAQlUwVd5dUYS4fLYbtOK
kYlYqc31d0vgg+L2ryZix3a1kwL16UCSHyHS3TUM9Zi9gC4j3UO+GkyiE/EmJYXZ
vhd/WDZ1fCM2ZIjvrwbhHMaWxoU1WBIW9946/01oFCxOG8gLLCc=
=Pzk9
-----END PGP SIGNATURE-----

--Uezjde4l4xS/mbfY--