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 1qEq6a-0007Rr-3p for pgsql-bugs@arkaria.postgresql.org; Thu, 29 Jun 2023 11:46: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 1qEq6X-0001O3-Jp for pgsql-bugs@arkaria.postgresql.org; Thu, 29 Jun 2023 11:46:29 +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 1qEq6X-0001Nu-5m for pgsql-bugs@lists.postgresql.org; Thu, 29 Jun 2023 11:46:29 +0000 Received: from mail-lj1-x22e.google.com ([2a00:1450:4864:20::22e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qEq6Q-0019tJ-Mm for pgsql-bugs@lists.postgresql.org; Thu, 29 Jun 2023 11:46:26 +0000 Received: by mail-lj1-x22e.google.com with SMTP id 38308e7fff4ca-2b6a152a933so8328131fa.1 for ; Thu, 29 Jun 2023 04:46:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1688039182; x=1690631182; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=9RZvk5U6WviDZXufNaNgp2qmZjsiZmTGfLnUnQhKfG4=; b=2IuAFxyAS4qisUfCViIQ2vmyN2pwwSZmjWEZyetb20AgMZPo0P3ACgtr9zNJdrHqXa l1K3fFgq+oDyyrxPNbEGueaos2P+k21cNp7TC1DSA2Qn3x+RJbu8OyzGzCF+SkB9R+rY jFyQDJLQ9CcPG6sD6kGnWX9Z+2VuajKzVc9pXS4Q3oqglIBwpEeAKMLdbfpep36o0qUY o4qYEtxx6M2hxpeVBnm+NkFKK3dL3m3RMBp6itunsiFIuy3VJEnFN6o3nDJhq2NqGxdH WgiNUS0UPik1POAcrDyz2n+Cs38KIc2fqTnNhp8LdOePonSu65tis3rlEY20VPS3M6wj kIPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688039182; x=1690631182; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=9RZvk5U6WviDZXufNaNgp2qmZjsiZmTGfLnUnQhKfG4=; b=Rg6dxu3U6XTlowRjj4v1eQ3r6YzAqx7HTNjb0NNYXjKQjDF3aBLhGksdBY2H4ybZbM Q33MQxsYMEumJlhkppdBlDOaTWomPZgrHazwazZ9uDonwheBh9PgZCfnQ6D9u8GR+fIK hTJZ8c5dH2SL14J4BmrqaRe3mI1JBKo0bPoGc2BCXyM/dkBcAlK3x5Pz9dsTOpVgs6zi oWuHnUiH+CUsdd0SCRZ5BSLtqEkQUyNib9zc87v9/70BOwEr2LleO+XrAK/QuO7qul51 z8uVTn6uKlUGSDKVDsKYkWNO/Rn8OjiCBl+IlsbcyY0rTkh5DHKhrgqKMgEJakz1F9fG JmLg== X-Gm-Message-State: AC+VfDwReO2P1Nqt2WXBs0F5jkST4aQ4W1Qcn52KVetHbWZf9Ck5bl7r ItXywsnEHxqVGuQCUaKxDS/80g== X-Google-Smtp-Source: ACHHUZ7LPyOgABzM2LeTlOqXsb226tvS5OeIuitt6WAKxBHnqSVtOUe82ttA7Beb5t5g/TAEgsBhrQ== X-Received: by 2002:a2e:9b52:0:b0:2b4:6f0c:4760 with SMTP id o18-20020a2e9b52000000b002b46f0c4760mr22256727ljj.11.1688039181603; Thu, 29 Jun 2023 04:46:21 -0700 (PDT) Received: from localhost.localdomain ([2001:620:130:6092:9eaa:2c5c:b1d4:9e96]) by smtp.gmail.com with ESMTPSA id r19-20020a1709064d1300b009920c9cb34asm3155933eju.50.2023.06.29.04.46.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 29 Jun 2023 04:46:21 -0700 (PDT) Message-ID: Subject: Re: BUG #18005: PSQL Process hangs in parallel mode From: Laurenz Albe To: ess.bee59@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 29 Jun 2023 13:46:20 +0200 In-Reply-To: <18005-5cd026ae9ac57c17@postgresql.org> References: <18005-5cd026ae9ac57c17@postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-06-29 at 06:15 +0000, PG Bug reporting form wrote: > For the planet the "sequential" calculation runs whithout errors, but it > needs 26 hours.=20 That's not a bug, and you'd better ask the -performance or -general mailing lists. Yours, Laurenz Albe