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.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1syyH4-003MMS-Vw
	for pgsql-general@arkaria.postgresql.org; Thu, 10 Oct 2024 18:52:35 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1syyH3-005LzF-UJ
	for pgsql-general@arkaria.postgresql.org; Thu, 10 Oct 2024 18:52:34 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1syyH3-005Lz6-JU
	for pgsql-general@lists.postgresql.org; Thu, 10 Oct 2024 18:52:33 +0000
Received: from smtp98.iad3a.emailsrvr.com ([173.203.187.98])
	by magus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1syyH0-000O7l-Kg
	for pgsql-general@lists.postgresql.org; Thu, 10 Oct 2024 18:52:33 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp13.relay.iad3a.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 91BEC3937;
	Thu, 10 Oct 2024 14:52:29 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Question on indexes
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAD=mzVWLN35FHPxN0Ajh2vnDkFLyg9f0vT6EKF9uPm7CYkHS5g@mail.gmail.com>
Date: Thu, 10 Oct 2024 11:51:58 -0700
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <56CE69DD-FFC8-45A4-8EF6-513BB011310F@thebuild.com>
References: <CAD=mzVWLN35FHPxN0Ajh2vnDkFLyg9f0vT6EKF9uPm7CYkHS5g@mail.gmail.com>
To: sud <suds1434@gmail.com>
X-Mailer: Apple Mail (2.3776.700.51)
X-Classification-ID: a10fe4ff-64d1-4798-832f-78ee883b62f4-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/56CE69DD-FFC8-45A4-8EF6-513BB011310F%40thebuild.com>
Precedence: bulk



> On Oct 10, 2024, at 11:49, sud <suds1434@gmail.com> wrote:
>=20
> Hi,
> I have never used any 'hash index' but saw documents in the past =
suggesting issues around hash index , like WAL doesnt generate for "hash =
index" which means we can't get the hash index back after crash also =
they are not applied to replicas etc.

That's very old information.  Hash indexes are correctly WAL-logged =
since (IIRC) version 10.=