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 1kmVln-0007FK-3E for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 05:42:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmVlm-0006D2-34 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 05:42:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kmVll-0006Cu-SH for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 05:42:37 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kmVlj-0003OC-RW for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 05:42:36 +0000 Received: by mail-oi1-x235.google.com with SMTP id x16so18294631oic.3 for ; Mon, 07 Dec 2020 21:42:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=ZtBa/j4+Ogq7wbsjXEa0Jux02AGS4ZZFj7Vh+Aici/k=; b=erXIKzmSKPy7pJUtQlEEtNKWWO3PfpN82k1aZCh2kEhqsE5a63EiyD6j8C1o7lpgQO c5jrmb4CGGW9LkqUT+AQ8GeQa77uow53WAlkVxjl1QkHNGm3ioSgQI839I8KWfVsF8vG P4CDDewOUXgSV/4ww2MyRJbmiFUVZY5+Z+LFlEFbaHo9qhMnL2uEpWuMvDevvx/XNgXQ yUx44+15AzHF9GfC6JAh51AGmAE8WfhHKLuEULk9RBwmgWurxyjqzHFgxr0hAaMOa/q5 si+GfA6ixQt/M6uEcjkQhzlLkXUFtaiyTEW7bws2Rjpu5PZjyxq5MBen18893DKTBc0y CZZA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=ZtBa/j4+Ogq7wbsjXEa0Jux02AGS4ZZFj7Vh+Aici/k=; b=uevjecvb3BdLCvwOjlwaQWQZeQ/ddutmbJVC6SVqwjuYXJ9CNpjpA5lRqCrSKmMop2 pTDYbB9ybGOHFHeyY0O5KemxMV6SbupT0JObDCHNbWLapJt5CLzXVGb89S/FcZNFYdHv t6pkPYRKXVug9MNJmDFlTcVrOFXUd+DasJLch9F7n2qkjpUHL6O7pQJJXk7KiZSWUbMF THrM/IuPSlJGtrFvHismGu6ECGW4XwYmGm5GPrgeRg+0LXRlDq5NZrbdtwkM2aPOqGkz ASasX7BkkipZqWqUheprEd2hpswzNFSkyU5AWe0/3uy2RUZQ0OmBr3t8bT/TYJgkBn5S 2BwA== X-Gm-Message-State: AOAM5315aWwz3oe0jZoDQWyKjxBvj90Yv8IAoDPE94twbqyepyoMd8Pb T1/9U1ZqzXPpf3xXw7mMMcfhZN7vvihTPA== X-Google-Smtp-Source: ABdhPJz2H9EyvgxT2yGTkHI7Vwstkrx01splhAZJAnDDDrmhReDnd9SbL5gwZFfj9zBMTxchzM9vLA== X-Received: by 2002:aca:5786:: with SMTP id l128mr1530467oib.145.1607406155171; Mon, 07 Dec 2020 21:42:35 -0800 (PST) Received: from [192.168.1.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id o135sm3132562ooo.38.2020.12.07.21.42.34 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 07 Dec 2020 21:42:34 -0800 (PST) Subject: Re: reindexing db To: pgsql-admin@lists.postgresql.org References: <292966DF-135C-4483-81A9-5027FC3C8A82@elevated-dev.com> From: Ron Message-ID: Date: Mon, 7 Dec 2020 23:42:33 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <292966DF-135C-4483-81A9-5027FC3C8A82@elevated-dev.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/7/20 6:45 PM, Scott Ribe wrote: > Does reindexdb ... Changing subjects, but the thought of reindexing every index, whether it needs it or not, in one command, seems like a crime against database administration. -- Angular momentum makes the world go 'round.