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 1vDRbl-0090o9-Ep for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Oct 2025 18:06:16 +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 1vDRbk-008jWr-0y for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Oct 2025 18:06:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vDRbj-008jWi-Fp for pgsql-hackers@lists.postgresql.org; Mon, 27 Oct 2025 18:06:14 +0000 Received: from mail-pf1-x436.google.com ([2607:f8b0:4864:20::436]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vDRbf-0044UA-23 for pgsql-hackers@postgresql.org; Mon, 27 Oct 2025 18:06:13 +0000 Received: by mail-pf1-x436.google.com with SMTP id d2e1a72fcca58-7a26b9a936aso2911450b3a.0 for ; Mon, 27 Oct 2025 11:06:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1761588369; x=1762193169; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=OYaGnopdgqSWOzSPGjU8BBtYFQWchOc5qYuiNcCmIv0=; b=dPKPeASVqKOCN3Vj8hroBoIApyUgScEYPofF5MiexWlF4DQ2Jh6gFwuaSy2VUqy2So tBuKXOa59jYq5JI8aWna04vHlNQPNd66LbRWYlCHuMrN2rKN1pEIzHg1+a4RplRLMKW3 8m2IJrggjDFzsAAHB+KfDnC711JbwMjNm9vvw= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761588369; x=1762193169; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=OYaGnopdgqSWOzSPGjU8BBtYFQWchOc5qYuiNcCmIv0=; b=AdxUDEa69w12Tb08UdLHXYqnnJq1eSzbTL9sGXrlVPZrvmDDbpXh3CQFQjmxMwEQAV cL4OyoupaFdiwvQJ/cH8eA9UhrTBYkdaYvgUCTa6woyr5PxOqWKfW5iikkXmSIxRuoQz 1Rx/72Tu3d9N+sZh3hORafsuVWkOixHbfozy78RFeVT4MyXSDMFvltmCBhmRj+wYrT9H TPvdAi2fx3uxG5Fq19BRP9jx839ON6jbNZ1faoEyJpabyGc6WTNgT54lklWFp2Hf9Lrd giECHNeiw8hqlDygT+YuCzhTPzfIWDLZauf/Gj6fDVsk4JJgO8NwryAgtWlPR5RQpTc5 57wQ== X-Forwarded-Encrypted: i=1; AJvYcCW4OP2bEp1LSYeZRKth2+jr/WMNeiE65b1709nbUQXP+VsxXqtA/kRkfep0+aQnX/MlRJTtxR4QvOWROp/C@postgresql.org X-Gm-Message-State: AOJu0YzCbSimYeRG20k3yJylDmIeuv7SFVuqo0eQcNvt/w3RUGVXC6Mo UOeUFIaab64XkArfrOE4bGHE9pD0rV/GnWLXtYEjBguQP1cUg0k4BISQgsfG7iVs3Q== X-Gm-Gg: ASbGncvOSsuwRsLynZr0SOzuvh0lF6GrlQqDc1G+ZJ2ytfDNrCXO0phNFnO+POb8ksc 9HKVM4d05eKe9xkb4qnDHJwmWi6wyGXdSWUVtoJrYaCoatvGV4YETWRkfirY9NZUCY/X62oz4KB 9D4eciUj14+IdIOMPACN4MDSLiPdbI7dmTDm4C9Pn8qQM8eiXnuAQmFzlN5L7/9kjv01VnCLTZm UkzIQRgK2zCMCO3suI8cQukfDp9o3KCU/WtIItognUCjyJWyLsGyqGtyoaTGf/SWSrTPJUy6jXi +/YEpdR5i9Z18ckDwx9TzBFQRLNPrrEPX71JrcOO5zvo6BwkrAZCETlsuZPPJFrepnSrYx3SXzi vHkdaiLyTn7MwxZ5vvoE6qZ3tdWM/LJl6CH5EcJzUFISkVMvE1V5gAjyrsoML2U4L8wwVZV4fiS E/9ZxNJORbk3yidj3Xu2SmGWwJvRVVdbqJevUfoAM= X-Google-Smtp-Source: AGHT+IGZtXIT9dZ8XeMeuh8atAKO7XNG1ERNBJHc0dL+3lnCIxWu8xmcaw5Wx+m7B62Xz7eMigX/hA== X-Received: by 2002:a05:6a00:99d:b0:77f:416e:de8e with SMTP id d2e1a72fcca58-7a441c377acmr798268b3a.26.1761588369400; Mon, 27 Oct 2025 11:06:09 -0700 (PDT) Received: from google.com (c-73-15-160-255.hsd1.ca.comcast.net. [73.15.160.255]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-7a4140530d3sm9002709b3a.40.2025.10.27.11.06.08 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 27 Oct 2025 11:06:08 -0700 (PDT) Date: Mon, 27 Oct 2025 11:06:06 -0700 From: Noah Misch To: Mihail Nikalayeu Cc: Michail Nikolaev , Michael Paquier , PostgreSQL Hackers Subject: Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Message-ID: <20251027180606.f4.nmisch@google.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Oct 20, 2025 at 09:27:00PM +0200, Mihail Nikalayeu wrote: > Some tests of stabilization, discussed in [0]. > > Also, an issue known for more then 1.5year... Should we at least document it? Yes, I'm happy to push a patch documenting it. Would you like to propose the specific doc patch? I regret lacking the bandwidth to review the fix patches. > [0]: https://www.postgresql.org/message-id/flat/CADzfLwUc%3DjtSUEaQCtyt8zTeOJ-gHZ8%3Dw_KJsVjDOYSLqaY9Lg%40mail.gmail.com