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 1r8D2f-008mYH-Nn for pgsql-general@arkaria.postgresql.org; Wed, 29 Nov 2023 05:23:22 +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 1r8D2a-0097Vy-QY for pgsql-general@arkaria.postgresql.org; Wed, 29 Nov 2023 05:23:16 +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 1r8D2Z-0097UK-68 for pgsql-general@lists.postgresql.org; Wed, 29 Nov 2023 05:23:16 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8D2S-0097Ls-Oc for pgsql-general@lists.postgresql.org; Wed, 29 Nov 2023 05:23:12 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id C2DDE3200B1A; Wed, 29 Nov 2023 00:23:04 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 29 Nov 2023 00:23:05 -0500 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:sender:subject:subject:to:to; s=fm3; t= 1701235384; x=1701321784; bh=SwzUi3eITt29uZuYmVQyVOGkCOiOsatSufb +p3ukoOM=; b=IQT2W1n31Ni/ruS+503vjpmfwvsDxzKFzM+8b69yoW1Oo0MEDM8 j/aXo3Q0Buvrts+Pja8uf7q2d/MxBa6eDzX+iG4qvF0CD1puta1I1iNmNqm8qbhy BjwzVNMVYuaZOFh7n2urmQjQncAMhuZiNXhAM7MxGdSa4lwNePtcpgowcS9/ow/k YJtk6mbRZd1n/i3V7TlRAQWwhyEZNXLY8c29/KtZnz2mnIMqlctWd7fW1j1LUS9K jho6eYc33yrDvDC9B39txQgf5JNHqmI5P/0B3opC6pxrjwdP1AghTOX6+lSSn/e4 jt4clkWEF0NaZ6u2ZEm6zB8oa/cNji3/A/g== 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:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1701235384; x=1701321784; bh=SwzUi3eITt29uZuYmVQyVOGkCOiOsatSufb +p3ukoOM=; b=l/f+JqpN1+p4Q3EIxDSKl8lbuI+DuGukdu64XgSJ8zrGUWwaaXM 7Kowa4Tn4RzaX4dPFWt4RsIC4B1VYTPFyNKyg2aM/cb8eBqWgU0Ldz/RzSO/5Oey VEVwuLQQD/05vCiaaQyELiRDcukQGqg7m9sfYEAg5gPNHC4Lhi56RmMcxbi1qd/9 S/Fvih4dvy+ubSU4NLdHqhlVJjz4jRvSBKC9fQINfi88I2Ux5mOgh9zzLgWsKeUn wLyt0mZY+khUliXcjDQcvu7WX+nhOPoZPX7PzOy8l4tFtBWBIrfwhbRgiAIkBeCY jUpiBBJKsDuEnWOmjd03BbuPQ/RjaKjaF7Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudeigedgkedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhepueduvedtkeevleeuleejheejgefhtdefudffgfeg keejleffkeeugefhheefkeegnecuffhomhgrihhnpegrmhgriihonhdrtghomhenucevlh hushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdr khhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 29 Nov 2023 00:23:03 -0500 (EST) Message-ID: <39765b00-74ae-4fea-91c5-c4e9b67f4c6b@aklaver.com> Date: Tue, 28 Nov 2023 21:23:01 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Understanding partial index selection To: Owen Nelson , Tom Lane Cc: pgsql-general@lists.postgresql.org References: <205440.1701222268@sss.pgh.pa.us> 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 11/28/23 18:13, Owen Nelson wrote: > > Aurora is not really Postgres > > Oh geez, I didn't realize there was such a divide. This is my first look > at Aurora and I thought it was just a hosted postgres offering. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_AuroraOverview.html#aur-shared-resp "Aurora includes a high-performance storage subsystem. Its MySQL- and PostgreSQL-compatible database engines are customized to take advantage of that fast distributed storage. " When I see things like *-compatible alarms start going off. > > Still, I'll take what I can get. Hopefully, some of this will carry over. -- Adrian Klaver adrian.klaver@aklaver.com