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 1kmXJU-0002PF-3s for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 07:21:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmXJS-0005lJ-Tw for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 07:21:30 +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 1kmXJS-0005lC-Kd for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 07:21:30 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kmXJQ-0006fl-Ux for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 07:21:29 +0000 Received: by mail-ej1-x630.google.com with SMTP id n26so23174309eju.6 for ; Mon, 07 Dec 2020 23:21:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Asxgw+CDYUV52ioK42oKb2MMWpTBdETxwClK60p+4Do=; b=drJosjP2DkjXOBw6qBexWK1kQXLniQzljK0pB2IH9KIr9+yxAX7gUIo7kfx3FmSS7I ycrT65/tG/3UWXBiz8g6ynL4oBUYvvAzperbtv/ClqzCK355HaSISL8OkRpxdy+d0oCW nhGW0ThDv7KfhWZo27S6gIXnzO0xAq9wtGzu2neCM3ZG4PNX87jRKxDdNdITTpqKuQ7i uWOq5uRf9H1UScoCRdVzd9hUyDAGPy88rDLHE5HkRMmg3JMYovBeK7QqCjTj5bsWi8sX axCQpaxXXeB8F6h//vT0WVNKWGekYpMFoRVmIqoLtAuSVEeMlVXggZo3A0B4o+MwoRa5 KHzA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Asxgw+CDYUV52ioK42oKb2MMWpTBdETxwClK60p+4Do=; b=iA1J1yy4LFDNLpbM79By8+fM4DbXKqULBFXNVBwaqLnxCdau6knJFZW1wn3LCjsSOX sWxBOoV0HMblc39A4ArxFJKNOrpKPGTCK5876YoX7uwCeOZECX4O23Q6XRDElHnd2bs+ 3RjuKK9O+zqV6psgp6FZSO/K3uyfDEWMUcYpRB2IRTz3wozaS8Lm0lD9D1z88f0o+mC5 L6Ztc08+NMS/i0VCXqannEwLRt1Gv5/rXEZwvEEjcx5ecrtdX3XdSA7YGgKgBHdOlVqy ZRL75vSFc8alH+IwJVmK4BR/yPxl/qaqSFJi4tXK0uVk6uSUl2LTw2w0reSpX6waV6+B NsgQ== X-Gm-Message-State: AOAM530aqdLNPzsquJIzRYAx8/IAuT06Bu5TwkVR+QP7YPzDulTcL2cg OgmOc1NehgMRXt+60BRyHVU= X-Google-Smtp-Source: ABdhPJwF5uEIT13qo6Nhhi69IHxe3YYIgRriwLgbYyReeZvMqCRWh+UL8Y3bL5jDJQTq561Z3vojQg== X-Received: by 2002:a17:906:2499:: with SMTP id e25mr22134674ejb.446.1607412088254; Mon, 07 Dec 2020 23:21:28 -0800 (PST) Received: from [192.168.1.8] (241-57-239-77.dyn.cable.fcom.ch. [77.239.57.241]) by smtp.gmail.com with ESMTPSA id cb14sm14779762ejb.105.2020.12.07.23.21.27 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 07 Dec 2020 23:21:27 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.20.0.2.21\)) Subject: Re: reindexing db From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: <39a8cdb5-bfbb-9ae8-5867-c4234373277c@gmail.com> Date: Tue, 8 Dec 2020 08:21:27 +0100 Cc: pgsql-admin@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <292966DF-135C-4483-81A9-5027FC3C8A82@elevated-dev.com> <214E5DBC-1F6F-49C1-8B83-9A2EB33E969A@gmail.com> <39a8cdb5-bfbb-9ae8-5867-c4234373277c@gmail.com> To: Ron X-Mailer: Apple Mail (2.3654.20.0.2.21) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Ron, > On 08. Dec, 2020, at 07:59, Ron wrote: >=20 > Probably a habit from my VAX/VMS days, but I prefer to enumerate every = table, not only for tracking but so that if the command fails 90% of the = way through, I can skip over the the completed portions. doing this IMHO defeats the purpose of concurrency because you'd have to = issue reindex statements sequentially. Also, but I definitely can't say = for sure, reindexdb should skip and report indexes which it has a = problem with and then continue to do the remaining indexes. But as I = said, I may be wrong with this. Cheers, Paul=