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 1kmXhr-0003Pd-UA for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 07:46:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmXhq-0008GD-Sc for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 07:46:42 +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 1kmXhq-0008G6-LI for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 07:46:42 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kmXho-0006tA-SF for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 07:46:42 +0000 Received: by mail-ej1-x636.google.com with SMTP id ce23so19504244ejb.8 for ; Mon, 07 Dec 2020 23:46:40 -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=UjVWzxH9JGnY1MW5F10W8I+IM9rcaiE677Y7/5v2vok=; b=SdWHoFdskXnOezpWEv/Mg+QJI/w8Q9UAJht37gWBub77wWQhPzDxb4RRLxdYvMAq8b 9OWxdgLXUOFLfnjazCqUbLLyffHoO3GpM5cLW5QcbwpppT/3BAefHxaDo0eOLEJSX2vy kOKWVngbCQjBwykOF1qSaUNEJhj317GRpoc9qUZLzk4GNSfsqTwSCTHSW3vUxk/B6chS uEgHGmy913m5b3Em2Jq9gil2RdBShnFbUggtvo4Ly0Sgok36bpfHJnBskRajzG8NHLWH VJ+0aQ8Q3tdFDiJcOauLL+alA/9UljNosMBtPgMVjMAxLboR+0F665ilLlvRhqe5/trv 6h4w== 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=UjVWzxH9JGnY1MW5F10W8I+IM9rcaiE677Y7/5v2vok=; b=izcLUO7GDfzFRXd5CaNvHMOFdqicMjvAS1YOWGMw87drR26CsppTgELq5xeQyWFSzb IKjRPieKJYfNYkOc5cwEuPS+enX4nh/b+9a5/1MPaeSn4VBsk5HzHjO0cJL2qsLrpgPW olhYgEgQLZaEF2HEK97PJep2tHUrYHHlsbF5nyXogRbIzKIZjNF+L8UXDI7uG0x5fhYL lT4HCHw5PY9QXFPWgudBFU4q4XvHQ7PiW8Lzst/s91ud2VLSMFonhqBS/+FxcSljfBSz pi8MZLEWKjh0RON9q9SG5RwovRaObwRBOuSU5+3dVhKEH1Jl4ep8Dkw4QpEliS0BAEb7 2t5g== X-Gm-Message-State: AOAM533ZP+28BGSfBKeYADqgJZn72fEJ3wPgjZTp6E2AMozyD4mkcFml 3kaN48X9MYU1babdNw7uQvA= X-Google-Smtp-Source: ABdhPJxFKcEFxhoY9zx2lfR4kef7eRl6Rdxaj49q3v3Ok0aKWKnE1fnzN7NFVL1atrAwqtEx70FOyQ== X-Received: by 2002:a17:906:c04d:: with SMTP id bm13mr21814017ejb.519.1607413600350; Mon, 07 Dec 2020 23:46:40 -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 f19sm14885462ejk.116.2020.12.07.23.46.39 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 07 Dec 2020 23:46:39 -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: <98c19d44-8d4c-f608-5432-eef048965552@gmail.com> Date: Tue, 8 Dec 2020 08:46:39 +0100 Cc: pgsql-admin@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <01FAC841-0FF0-4B63-A507-C76EFB62A97F@gmail.com> 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> 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 08:42, Ron wrote: >=20 > DB=3Dtest > while read line;=20 > do=20 > psql $DB "REINDEX TABLE $line CONCURRENTLY;"=20 > done < list_of_tables.txt yes, you can do that of course. In this case, I would add an "&" after = the psql and probably a "wait" at the end. This should get the job done = in parallel. :-) That of course depends on how fast the machine is and how much load it = can take. :-) Cheers, Paul=