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 ) id 1uhzse-006RSh-DD for pgsql-general@arkaria.postgresql.org; Sat, 02 Aug 2025 00:13:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uhzsc-00AAzf-Jo for pgsql-general@arkaria.postgresql.org; Sat, 02 Aug 2025 00:13:42 +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 ) id 1uhzsb-00AAzT-CV for pgsql-general@lists.postgresql.org; Sat, 02 Aug 2025 00:13:42 +0000 Received: from fhigh-b5-smtp.messagingengine.com ([202.12.124.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uhzsX-000IBJ-27 for pgsql-general@lists.postgresql.org; Sat, 02 Aug 2025 00:13:40 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfhigh.stl.internal (Postfix) with ESMTP id D57807A0071; Fri, 1 Aug 2025 20:13:34 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Fri, 01 Aug 2025 20:13:35 -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=fm2; t=1754093614; x=1754180014; bh=+Drt60rgd/+YLGBZv6CraHvAFbSE8giSJDswhTG4qKA=; b= mJOaLOFc8AlL+dhgjo/BPS9xA+dHWs+Z463uOrqi7zLYXQVvN+YL3Mu886D1Znui 0EMFxxQaqhcazC7MVwseUjp/U7JmRuxRBFms42+rLNg78CcwOP+zOsZqLcYFZHoV lpJhvxPIk6hv6LP1mZ2epmfLmmjWJuCv5rtDtUGm3KlR9/AibSNdvYupUO/rFBNb sFnU3T5m7ENk/AalBXh1meBpPHbh9LmJl+nCzG4Yuhu2XVB3ip9WWjdXxpVTYRIo ZnyQjAabXet+m4J/rsBlMpPBsmml7cM3+NtuCc9DqRRvP4nio2w3YRGPfU0Kdvyf ANLRvfr6U9NIypJPEz9maQ== 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=fm3; t=1754093614; x= 1754180014; bh=+Drt60rgd/+YLGBZv6CraHvAFbSE8giSJDswhTG4qKA=; b=T 1DiZymIgjcvlT+jNCFgnLVG3Zgcl5W5vj67vpSkNsAXWz3+WSgEIRsveqfppEnnX sE4jXITGnD4NEtgWixncK4lQqhqi9cEY0TXflMlFDEZhOCV8BaHzKpGhGVqsI8oP 5F0CAzq/c6u+qcc/g/KtAt0J2Bm7WBc2HHxkqPsrK4bYQTVbxoIsaPcwZbxMJtPS ZCohhykSz/OrBOOkco+Or2ndasxM8lF7JLyMiqJ5J3e14k2JsPaepcvWthaELZF3 QjLCdd17dRgaGTuR8OQ+VycAHJk+n/P9+3ZuBKwdFluooziWhsoUYNn5HOLsHr7a WymtrR2/tss89g0oX6Kfw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgddutdehuddtucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgr nhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh eqnecuggftrfgrthhtvghrnhepuedufeejjefggfdttdeghefgkeeuveekkeeiteettdek ffehiedvtefhveffgeeunecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenuc evlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgr nhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopeeipdhmoh guvgepshhmthhpohhuthdprhgtphhtthhopehikhhorhhothdtudesghhmrghilhdrtgho mhdprhgtphhtthhopehlrghurhgvnhiirdgrlhgsvgestgihsggvrhhtvggtrdgrthdprh gtphhtthhopegurghvihgurdgsrghrsghouhhrsegrmhhirhgrlhgvrghrnhhinhhgrdgt ohhmpdhrtghpthhtohepiigvphhpihgvrhhisehgmhgrihhlrdgtohhmpdhrtghpthhtoh epgihofhesthhhvggsuhhilhgurdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgv rhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 1 Aug 2025 20:13:33 -0400 (EDT) Message-ID: Date: Fri, 1 Aug 2025 17:13:32 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Get info about the index To: Igor Korot , Laurenz Albe Cc: David Barbour , Jon Zeppieri , Christophe Pettus , "pgsql-generallists.postgresql.org" References: <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com> <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com> <7281c379994ffc70cebb68423f5b8ba339d0d75f.camel@cybertec.at> <2fad4427bff83bc73f9b4215e284a76343f046f2.camel@cybertec.at> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 8/1/25 17:06, Igor Korot wrote: > Hi, Laurenz, > > I'm looking at the pg_index table and I see it has: > > [quote] > indisexclusion bool > > If true, this index supports an exclusion constraint > [/quote] > > If I read the docs correctly, this field indicates whether the > WHERE condition is actually present. > > Am I right? No, it refers to: https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-EXCLUSION > > Thank you. > >> >> Yours, >> Laurenz Albe -- Adrian Klaver adrian.klaver@aklaver.com