Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q8p58-0003Ez-Hb for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Jun 2023 21:28:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q8p49-0006lz-De for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Jun 2023 21:27:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q8p49-0006lq-49 for pgsql-hackers@lists.postgresql.org; Mon, 12 Jun 2023 21:27:09 +0000 Received: from mx.post.pl ([89.161.251.167]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q8p46-001zxv-5i for pgsql-hackers@lists.postgresql.org; Mon, 12 Jun 2023 21:27:08 +0000 Received: from serenity.fritz.box (aftr-82-135-80-142.dynamic.mnet-online.de [82.135.80.142]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by mail02.home.net.pl (Postfix) with ESMTPSA id 11335327E1; Mon, 12 Jun 2023 23:27:04 +0200 (CEST) Message-ID: Subject: Re: index prefetching From: Tomasz Rybak To: Tomas Vondra , PostgreSQL Hackers Cc: Georgios Date: Mon, 12 Jun 2023 23:27:04 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.2-1 MIME-Version: 1.0 X-CLIENT-IP: 82.135.80.142 X-CLIENT-HOSTNAME: aftr-82-135-80-142.dynamic.mnet-online.de X-VADE-SPAMSTATE: clean X-VADE-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgedvhedrgeduhedgudeitdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfjqffogffrnfdpggftiffpkfenuceurghilhhouhhtmecuudehtdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurhepkffuhffvveffjghftgfgfgggsehtqhertddtreejnecuhfhrohhmpefvohhmrghsiicutfihsggrkhcuoehtohhmrghsiidrrhihsggrkhesphhoshhtrdhplheqnecuggftrfgrthhtvghrnhepleelgfegueeggfejffehjeeglefhfeejlefhtdehleegiefgueejkeejvdffleeinecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfkphepkedvrddufeehrdektddrudegvdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpeekvddrudefhedrkedtrddugedvpdhhvghlohepshgvrhgvnhhithihrdhfrhhithiirdgsohigpdhmrghilhhfrhhomhepvfhomhgrshiiucfthigsrghkuceothhomhgrshiirdhrhigsrghksehpohhsthdrphhlqedpnhgspghrtghpthhtohepfedprhgtphhtthhopehtohhmrghsrdhvohhnughrrgesvghnthgvrhhprhhishgvuggsrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepghhkohhkohhlrghtohhssehprhhothhonhhmrghilhdrtghomh X-DCC--Metrics: mail02.home.net.pl 1024; Body=3 Fuz1=3 Fuz2=3 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-06-08 at 17:40 +0200, Tomas Vondra wrote: > Hi, >=20 > At pgcon unconference I presented a PoC patch adding prefetching for > indexes, along with some benchmark results demonstrating the (pretty > significant) benefits etc. The feedback was quite positive, so let me > share the current patch more widely. >=20 I added entry to=20 https://wiki.postgresql.org/wiki/PgCon_2023_Developer_Unconference based on notes I took during that session. Hope it helps. --=20 Tomasz Rybak, Debian Developer GPG: A565 CE64 F866 A258 4DDC=C2=A0F9C7 ECB7 3E37 E887 AA8C