Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkKpw-0007Vk-Mm for pgsql-bugs@arkaria.postgresql.org; Tue, 09 Nov 2021 06:42:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mkKpu-0004zs-F3 for pgsql-bugs@arkaria.postgresql.org; Tue, 09 Nov 2021 06:42:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkKpu-0004zj-6L for pgsql-bugs@lists.postgresql.org; Tue, 09 Nov 2021 06:42:26 +0000 Received: from mail-qv1-xf35.google.com ([2607:f8b0:4864:20::f35]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mkKpr-0002ED-Vo for pgsql-bugs@lists.postgresql.org; Tue, 09 Nov 2021 06:42:25 +0000 Received: by mail-qv1-xf35.google.com with SMTP id b11so13613783qvm.7 for ; Mon, 08 Nov 2021 22:42:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=IAkdzzfjheg9KKrJtyqCn4dUptiCH1ecBUjRxionGA4=; b=E8bv8VJ9Jo27oZToh08S2rH7jBRMGIH9TZbeOcSmPnjqVJrO+Ku2R0x1+9zwLBTGXu qT617/SSuqBjnUxdSRBUC3ZYMPf2RvltOotN9jr1mDgVioNfdF1hwUkyWyTOX+l/ZTgn vKAscPnSr96rcPNXEaSVcyjMmNu/LkQqY/Mqs= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=IAkdzzfjheg9KKrJtyqCn4dUptiCH1ecBUjRxionGA4=; b=VL6Ag/xrpUA5f9TFWRk8OueQLABTL8PAY7sjcDfdAxhkvLJgFIIcF1aekzrJELAZw5 YZLq4Kp9wRrk6oKSUnlis8u7iI6WlypI5l9J6Jlz8CdJn4ScL8FPeaS3OS4772h4BDGn eFwIxpAkb5fRXpQQBR9SWDl0m1cU50InnddcjLNLMsrtOmqD/eR7zT0G4vvxmYS18ntT qg4DhnqWWkO+VF6ple+CIDjeNW9vdirVFcW1XTcFsMXf4E1TSF8Z2Mb83pDE60SyRb2t 7qaWyzwsjChUzx4tzul0bMDeuIzqWRmCbYDONoqxBUcW2AIUmo9GINjVt8GWt16fUV1a KRiw== X-Gm-Message-State: AOAM532rkVt9uPWpnsyC+iWJv6PB8Lv+3tNWhSpTvaGSzMrRMLZTNWAv 69yPP/B/uD8K0yw+2WQc9EycpQ== X-Google-Smtp-Source: ABdhPJzP1IoG1YgLSYr6kuSC1HugZmf2k+jee9VheCLywv5Zo1BghWX3XwHvTgaEt2ySA36O0kuRBA== X-Received: by 2002:a05:6214:f2d:: with SMTP id iw13mr24777764qvb.13.1636440141154; Mon, 08 Nov 2021 22:42:21 -0800 (PST) Received: from rfd.leadboat.com ([2600:1702:a20:5750::46]) by smtp.gmail.com with ESMTPSA id u8sm11692256qkp.21.2021.11.08.22.42.19 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 08 Nov 2021 22:42:20 -0800 (PST) Date: Mon, 8 Nov 2021 22:42:17 -0800 From: Noah Misch To: Andres Freund Cc: Michael Paquier , Alexey Ermakov , Robert Haas , Maxim Boguk , PostgreSQL mailing lists , Peter Geoghegan Subject: Re: BUG #17268: Possible corruption in toast index after reindex index concurrently Message-ID: <20211109064217.GC940092@rfd.leadboat.com> References: <366f7247-709e-c07c-4875-068be1121c3a@dataegret.com> <20211108183646.r3y6pldylxngxwl4@alap3.anarazel.de> <20211108185317.fz42txmnkqdkpix6@alap3.anarazel.de> <20211108203641.whpia3pzjofellf4@alap3.anarazel.de> <20211109035624.GA940092@rfd.leadboat.com> <20211109050848.oe3u6mhtomkaoxrx@alap3.anarazel.de> <20211109054625.GB940092@rfd.leadboat.com> <20211109063119.ukcvdk7uvz7ks3pa@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20211109063119.ukcvdk7uvz7ks3pa@alap3.anarazel.de> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Nov 08, 2021 at 10:31:19PM -0800, Andres Freund wrote: > On 2021-11-08 21:46:25 -0800, Noah Misch wrote: > > Doing both sounds harmless. Regarding REINDEX CONCURRENTLY on a system > > catalog, I bet that can still reach bugs even if we do both, considering this: > > Normal catalog aren't REINDEX CONCURRENTLY. It's just toast tables that are > kind of system-y, but also kind of not, that can be reindexed concurrently. Oh, okay.