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 1qqpmI-001Gsf-Gm for pgsql-sql@arkaria.postgresql.org; Thu, 12 Oct 2023 07:06:38 +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 1qqpmG-0048Fr-Az for pgsql-sql@arkaria.postgresql.org; Thu, 12 Oct 2023 07:06:37 +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 1qqpmF-0048Eq-AJ for pgsql-sql@lists.postgresql.org; Thu, 12 Oct 2023 07:06:36 +0000 Received: from mail-me3aus01olkn2141.outbound.protection.outlook.com ([40.92.63.141] helo=AUS01-ME3-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qqpmB-0007kC-8A for pgsql-sql@postgresql.org; Thu, 12 Oct 2023 07:06:35 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=T7XgdAgxaK+0rkSNz7F/qaMIV2nZRyNpYZda81wp5EXYFKqkaBy9XaBykhQcDP+oS7LmKVIKJBCYmBuNEc1i7KAmoITUFouqq/dgTMvsGd1YUYdZ3ahkt82a80m2MZXDYNLd+9rpHFeKHJEgDmYdyionUd3hoRhD8bqyiNwJy1+fWN/6gZmEEzkmjDZgoSEda7BIlQWzbT2z+w3JfdgXMXGtHXT9cIspc2pYoJeiAxJJ3gKAI4K6zzHCPB6hieq64xUG2KB+RHNYUb1zPzPf030XTxIxF+gbmZvWymLh7e1YU6tdvSMG6zmgsSPoVR9t4iMzPVxPEcSKhTCAqhDLnQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Wm72qGJqlMGjAfTDwWl6D7K52Z4u1JW3eMNFJxUljoY=; b=ZnGNxcsNNkBlalQ0tWjftGJ+ckYiX88DVuZANLp9G+k5dQVLty4xxE7OrVj0C+GKGaveH8NrE+YwOHNd6X2qvwd1V4SEyGXvfB/7Z1ObvZpJb2wu6/5R4cdiw3WWDGCmc5J6JR6dZJoTnM+9SC/+89H7YLcCzVrLF1bEDU4BWZ46wwTqvOEq84ll8gvdLLCO6qa7TED5TnXME0WcMXY7P/KM/W7N1O2dvOJc+/URmpok4GYxUDzSyXAcd/j4VJl081PPoeR2hYMrpq/rFSEoA5tnXsy5ABxhgiDYkgViuqFL8RHec1tHLLb6wkWurfbLB0C4PMJsUJOgN49Rghdckw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Wm72qGJqlMGjAfTDwWl6D7K52Z4u1JW3eMNFJxUljoY=; b=iPkvvxnIbkRXjEiSeP8A92MTHZBz+WnF7bozfIG6ZwkUuUBii6uQvB+d/6vqVJQJGDv70mgkjl1BGcXLRtdG4BB6iTbvryKqU9RFoLPE8l6A/G9F9K/JU4S6XU/sdXy9Mgd5aOCSmH6RTh3qsVWwMoAYOvBgYSW+nwQan/UIWJzWrOWpWMboqIY7xvDSj8O2DejJsOCfrBn+wla2w0+rBDi8awHhC5hIIIUbdrjAEhdVENEt1PmvVBpiAbeOdtvsb4iPaQISpeP+Psh7wV9BkkOUFz0ir4ac1pfIRLLE5YawH1fc+J3+uQmvVuhTmoHZ2tMQ7TK/iTNd/KwGxJ9Xeg== Received: from MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:c3::12) by ME4P282MB1253.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:9c::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6863.41; Thu, 12 Oct 2023 07:06:26 +0000 Received: from MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM ([fe80::b98e:aa0d:204d:dcf4]) by MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM ([fe80::b98e:aa0d:204d:dcf4%4]) with mapi id 15.20.6863.043; Thu, 12 Oct 2023 07:06:25 +0000 User-agent: mu4e 1.4.15; emacs 28.1 From: Japin Li To: pgsql-sql@postgresql.org Subject: Could not use index because of indcheckxmin is true Date: Thu, 12 Oct 2023 15:06:17 +0800 Message-ID: Content-Type: text/plain X-TMN: [Sxfv571PiPvJRxyRAAKOC/WMlykqL5bk3+3wZSBZHNA=] X-ClientProxiedBy: TYWPR01CA0047.jpnprd01.prod.outlook.com (2603:1096:400:17f::12) To MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:c3::12) X-Microsoft-Original-Message-ID: <86edi0qpzq.fsf@hotmail.com> MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 X-MS-PublicTrafficType: Email X-MS-TrafficTypeDiagnostic: MEYP282MB1669:EE_|ME4P282MB1253:EE_ X-MS-Office365-Filtering-Correlation-Id: 6392852a-f9e8-41fa-a369-08dbcaf1bf12 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: 7hmFk8h8KVFb5qQ4xDb+PqDVfebYPigfjbSJQtk7w++i8k8mnLlH4aAuFpZLxBO0YjCZ+8MWQt1TVMGhvix+hLGHh+NcwI7Y4HZBipXh/aEyPV8hTkNEqI08gzBtXNvMEdwbKogNVMZlVc+d9CmZGEbteffRuvDvc2aWJgQ4g7/6aMvoNgj0GXFSBBlVJxnDPbyVZQpjoBKqlYufBWax8F+P8n0lLwTiyUylvKj0WDeiq+Ra6SEAV3VuUtSA0ZfJr7kmZiJjzdZARguPTe47F9dHrhKbcKN+MDyZD48u3OWZzr2EZ4dQz/nfquHK6d5K/h+OHJgd2llNJzHD/CwRTsAJKxGM3XOi7z8mhGorsnR8odvSGUuAw9RRwr8tuSwsZvJLzjnbzlKcFMa5VU1AFSGBQx1xK7dZEb9PqAxAMgbMNsTo/unRyfI+q3zKncqcAIIPL7NzHvqpqO1xcOg9gzMmaBS4kdEsv/hTqTDUlBV61ZTLKZf4RFzvWedH9p8NnvEENjoy9ERb3X3DqcffIKS2Z3m8mZV54HuhBJuUbEe2YOCoBU6IoGlr9tN7wSLTkUFyPQvwT2UdpiBCiq5nqbBK6XFFy5PIRL7NzZKJACs= X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?xijYHFMDrsBkrfJ4pVVi5OoPe8sAYeZj2e19OZCAfg/e356fKVpN9a6mr1o0?= =?us-ascii?Q?MlH57C5km1QwWtNwbTRQR6xD+XdnknTeJmOkwypn0WrOB/IkA7/CZvRHLil+?= =?us-ascii?Q?Vt19J9Kg/M/10Eb3h734izaVpb1TSjXKOfawPIAjH2gmqqdefnD8oFAdo5vu?= =?us-ascii?Q?6NnGM5b0cPZLcRbozZTJgAL/28HBN7KOHl1CyhYUP4XuhUne3j9qQWXz6qNY?= =?us-ascii?Q?gYW72HsELE0HAEdmVFqv/fco8HbHhA2WYKQfu84GJHgH9JafCqzH5JztrIhl?= =?us-ascii?Q?1W+jCTpUhcw86cxAYMikaUTE576RxB97rQg7lpYdXY8nWEalbMfEe4cd0Yob?= =?us-ascii?Q?QJwHxeiyBFs3wQtmnopLNPxJ9CHVtm5gbU5uKg2AJGfwD4me/3g17U8Q4LZM?= =?us-ascii?Q?5fN5KNR+lXLUwBpSYofT1102f1zI5YtXHg3RWWoBBnZG/J7g1zdaNmwiSRtu?= =?us-ascii?Q?lxXzDVw7o9M3yz4cTLOV6DP/eTrY4jXh4MNnzHOiP0/f+e0eEw9b+uvvIwdu?= =?us-ascii?Q?wD7CQhJVeghPeYIevu+8EposgHahuXm6uHN7Jpj8Go00ARTJ5nnip9gcdDrP?= =?us-ascii?Q?UMqrp/8UEISDskbTLqsvVDQJfcdQAnKADcvTf57IMGcZQd5hZcb92xbFh6K5?= =?us-ascii?Q?PlSnw6SgdU1InD7MSwVSfdBAY3AbJ+nUzHwE9xyPHwyAF41lXyzA3pDG1ruH?= =?us-ascii?Q?TVz36X3gPO25+XDDrsjwkzZSkZgfAPLx8eauUCbNmzpM6aoZPGCKrdXGww+E?= =?us-ascii?Q?AbJThC2IHWg2bYA/lUiMg+RDT2hOvL78o9uvQvCgioBDlswpfH/f9Ks/KqOp?= =?us-ascii?Q?2E4eP+lA+0ypMu/LOdNI3wzk5eXXhokHH/Pkr4V1d30LXzTjZn+mSN8BNBBZ?= =?us-ascii?Q?UGnoreDP0lARRAJy7Uc5rkQFzOMMhv1vWxODBhO91oQKyN2RV5V/n2lHBa+k?= =?us-ascii?Q?1k88eksV49Z2BzdLHSOE6ROUptszsD2puv9qx9VUSu4EVXfWdx1DQEMWchxl?= =?us-ascii?Q?gpqfk7JrLUD+qQGw4upnUUShJBUwaeE/O/3dLvmnGe5lAFRtNsPn1lwlxel+?= =?us-ascii?Q?Ofx5LMKqbeNS0fCtFsqf1FSUaCRT4236xUy91FEpyiBb5MqxpUX9elPQr3pl?= =?us-ascii?Q?FLMKB5UGyg01pENLv7I2v3EHfHEnCY95dJRMvbXIz+/mkjNnXvxjXZ/ZtqS4?= =?us-ascii?Q?ZT6sxRLTPKsyAW+P+Nf7kng4AIf4M5fIvtLWmg=3D=3D?= X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-746f3.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: 6392852a-f9e8-41fa-a369-08dbcaf1bf12 X-MS-Exchange-CrossTenant-AuthSource: MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 12 Oct 2023 07:06:25.8180 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: ME4P282MB1253 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, When I create an index using CREATE INDEX (without concurrently), I get an index which indcheckxmin is true. According to the docs[1], it cannot be used with indcheckxmin is ture, how can I fix this? > indcheckxmin bool > If true, queries must not use the index until the xmin of this pg_index > row is below their TransactionXmin event horizon, because the table may > contain broken HOT chains with incompatible rows that they can see [1] https://www.postgresql.org/docs/current/catalog-pg-index.html -- Regrads, Japin Li