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 1kmdwS-0000Mk-Vz for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 14:26:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmdwR-0005Fw-61 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 14:26:11 +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 1kmdwQ-0005Fp-Rw for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 14:26:10 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kmdwM-0001eu-5g for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 14:26:10 +0000 Received: by mail-oi1-x230.google.com with SMTP id f132so5084971oib.12 for ; Tue, 08 Dec 2020 06:26:05 -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-language; bh=QdL2EpJpK8b6OZUwz+nqptAgNAF2yvJBF8GufZtk5qM=; b=Qk8lNbIS18f9NRPx1ksAuX9ME6B/8WiFvBXk+YSJo8xm+NYihMtidiVAeHRq0Anwbb 4X+GhZxrMdpZ1tACsRC/nd9AhnQjF59LxudBcFlwG6hb2aq1lCcFq16zxh7l2K5Vfryz EClvF+5WtnuFlikZpNeU2GcF/mNy1xuVbIUUyQx8tdt2/7fG96P4sbeu84BQm/2E8/Ax xNj4fXDfTNW6Z3+mRcbKp9CIE4USF+zU8CT9HrLGUcl8IBx25521GLI9h4JX2ZF6RxEU C20gU6Lebq1011CpB7eLG5pT9Ru/se5P7/gLMrv1Z+BDV2+//Q+Hhf6juash6dg2AB2y 95Hg== 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-language; bh=QdL2EpJpK8b6OZUwz+nqptAgNAF2yvJBF8GufZtk5qM=; b=dC75zvLNPEflutHz7+o3GiBNC6GgseiwqUkOxOMmt1pMmc6q9D/6s6Lrj5dIfFV29Q ciNB68r2c3tAoBY1Gh5qLFyiC8UKYLz7moJBRm3VDb8V9hoMy3i03K7Rfb/DNS3QQTVs qJ9eIkuExbB9+UPe2ImF1/5IuXf6ehAuDypYzuOmQKU1ZxIA0DyzBDrRcQrbju1TEi/t VTvTizs+dcxGm/vl/RAHx8YqptCs/0abam/W8YH7XW+dYpAjpEuxGWwGDwMFEg22rnz5 TWZXTIii1JrWi8F7nBlEAWOABVZ0ORiPhTz8usfd+9kTBHWD/cUIrldZlXPMTg0Y4/Gz QH1Q== X-Gm-Message-State: AOAM530S0+Alzf5p2URYPd0eBDh89IJGOLO/Pp8QjxJfwIOVdaaoMFSQ 9qALd2fhVTuZJ5c3Ut8bJagXhj2niE/sBQ== X-Google-Smtp-Source: ABdhPJwLSaejP2QQVp0IetXewYJqgzK/NTu7osk0XmyXScKDgG44csDxvaU5WSvSA+/D08RaxHPSGQ== X-Received: by 2002:a05:6808:24d:: with SMTP id m13mr2917507oie.106.1607437563807; Tue, 08 Dec 2020 06:26:03 -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 j9sm3708609oij.44.2020.12.08.06.26.02 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 08 Dec 2020 06:26:03 -0800 (PST) Subject: Re: reindexing db To: pgsql-admin@lists.postgresql.org References: <292966DF-135C-4483-81A9-5027FC3C8A82@elevated-dev.com> <214E5DBC-1F6F-49C1-8B83-9A2EB33E969A@gmail.com> <39a8cdb5-bfbb-9ae8-5867-c4234373277c@gmail.com> <98c19d44-8d4c-f608-5432-eef048965552@gmail.com> <01FAC841-0FF0-4B63-A507-C76EFB62A97F@gmail.com> <5cd1d643-b205-57cb-dd80-7054ffb0facc@gmail.com> From: Ron Message-ID: <86a497e6-54d5-7748-b81a-7d5ce73d0c31@gmail.com> Date: Tue, 8 Dec 2020 08:26:02 -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: Content-Type: multipart/alternative; boundary="------------27299636C9378277D9DD19B6" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------27299636C9378277D9DD19B6 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 12/8/20 4:01 AM, Paul Förster wrote: > Hi Ron, > >> On 08. Dec, 2020, at 09:32, Ron wrote: >> >> The purpose of GNU Parallels is to not flood a system. Adding the "--jobs=" feature to reindexdb (along with enumerating tables using "--tables") would serve the same purpose. > I forgot about the -j option, sorry, my bad. The "--jobs" option does not exist (in v12, at least.) *Adding* that feature to reindex would serve the same purpose as GNU Parallels. -- Angular momentum makes the world go 'round. --------------27299636C9378277D9DD19B6 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit On 12/8/20 4:01 AM, Paul Förster wrote:
Hi Ron,


On 08. Dec, 2020, at 09:32, Ron <ronljohnsonjr@gmail.com> wrote:

The purpose of GNU Parallels is to not flood a system.  Adding the "--jobs=" feature to reindexdb (along with enumerating tables using "--tables") would serve the same purpose.

I forgot about the -j option, sorry, my bad.

The "--jobs" option does not exist (in v12, at least.)  Adding that feature to reindex would serve the same purpose as GNU Parallels.

--
Angular momentum makes the world go 'round.
--------------27299636C9378277D9DD19B6--