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 1kmZoH-00089f-41 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 10:01:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmZoF-0000dd-Se for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 10:01:27 +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 1kmZoF-0000dV-JS for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 10:01:27 +0000 Received: from mail-ed1-x52f.google.com ([2a00:1450:4864:20::52f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kmZoB-00080l-SO for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 10:01:26 +0000 Received: by mail-ed1-x52f.google.com with SMTP id i24so9068424edj.8 for ; Tue, 08 Dec 2020 02:01:23 -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=7MBYLOrDh72M9gABVccRsKRitnWVZE2Sdn4b4zPNeNM=; b=nGcx6j8pMQ73lU/QuGze6Kl6uDr8NTEOnI9yXIH4yeE+NnQ8DkEf4SwYaju1dKG59j EU1UFI2v1lZvpSc5gAMHD1kaE0A8rnYGXW3+SFlzGhfZ0p/zoVPGnIzWn+1BK6gqfgrr sI61YmZ9vCJZa69aMcmBHFM5rV6Jq09FhFLhhTe3liFPOT9UVXo6MhUyt+PI/1adofgW msHe3oPYqfvIr+EnKfhimkbYXq2I/tIA+WHWSDhrxH5MZx9J60yyF3IUVY0Tehuvel2f 81uWyhYwNqfAw0ZV6fmAgzCGpv8J2kc6Z28bL3vgarkt1NoZposmarI+k4ClHqCEwKou tyxw== 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=7MBYLOrDh72M9gABVccRsKRitnWVZE2Sdn4b4zPNeNM=; b=Ik0k8ZsjVltbK+LMxQJeXL3fggXm+mdkww8vsNjQLxDs30WYajP5PEmujVbnjybj0B tOi0jSke17vtYKRRmqNoalcrePZc8ZDzckLx4FjLi0RLAaAKzZNQyWD9l6TptZ6ob+Ae pKbBTXcgcS2BfFx7im4CCyQZ8MIe5hl6HHRN5HLKtG/ZfDBVd+SdgWd8Yu3VcQIcdXQN XUrCKRKpb0Ujn0nLbTxF2+Byy7DGyC8PYKaHCqMicdINBLJKNYnr54h0MMDEl76706LP /f6vuwrVU07fZorPTB3qnjDgw5BrPLlDd4QJDxKSOH9VQ7mVhUKvNvmyaj5sccyNHsfq bcvw== X-Gm-Message-State: AOAM532djUJM6ZKWPwxS/6PHcLB7bM1GXfYUT7bPlEshRRuakKlMUtHc HfjJCc89CzD8TFf5SSrT3Gg= X-Google-Smtp-Source: ABdhPJzRnqVqK6JVTpCPIAdbM03QbavmBTZhfNCaV6zhv6PuXu/cPyoatEVZXwR0WssnfO/EOspSVQ== X-Received: by 2002:a05:6402:7d7:: with SMTP id u23mr11998403edy.325.1607421682879; Tue, 08 Dec 2020 02:01:22 -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 f11sm15111611ejd.40.2020.12.08.02.01.21 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 08 Dec 2020 02:01:22 -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: <5cd1d643-b205-57cb-dd80-7054ffb0facc@gmail.com> Date: Tue, 8 Dec 2020 11:01:21 +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> <98c19d44-8d4c-f608-5432-eef048965552@gmail.com> <01FAC841-0FF0-4B63-A507-C76EFB62A97F@gmail.com> <5cd1d643-b205-57cb-dd80-7054ffb0facc@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 09:32, Ron wrote: >=20 > The purpose of GNU Parallels is to not flood a system. Adding the = "--jobs=3D" feature to reindexdb (along with enumerating tables using = "--tables") would serve the same purpose. I forgot about the -j option, sorry, my bad. Cheers, Paul=