Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szm3N-007wvd-8j for pgsql-bugs@arkaria.postgresql.org; Sun, 13 Oct 2024 00:01:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1szm3J-00CKPS-1l for pgsql-bugs@arkaria.postgresql.org; Sun, 13 Oct 2024 00:01:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szm3I-00CKPJ-Mc for pgsql-bugs@lists.postgresql.org; Sun, 13 Oct 2024 00:01:41 +0000 Received: from mail-pl1-x630.google.com ([2607:f8b0:4864:20::630]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1szm3C-000ar9-Rr for pgsql-bugs@lists.postgresql.org; Sun, 13 Oct 2024 00:01:39 +0000 Received: by mail-pl1-x630.google.com with SMTP id d9443c01a7336-20cdb889222so1140195ad.3 for ; Sat, 12 Oct 2024 17:01:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1728777694; x=1729382494; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=t9VcveGu/NxOxTj5bcGe4vOOsa1lkuLS/Vumxvc23Qk=; b=FRMSZEttcxU9TASzT08eVGsUU2J9EXVInX2jBxA3iox3Zv+/zWz0xzBqCgTYOo12ho B52QfPhtNtiJrQZkShd15MzP16sffBWMsmny8cK/SAAp+yFtLjhKbI5+QsxQV5t+3ERR 20JWL9fBM7KmUzWKKbd+umxcX6wuNyKLFYFnZ6QUyFlJV9Qc/O/zaDiIctr07Un+kZ42 I4ylF6rYaeyfmqgNmw0FrHIPTPnsDL/T/mE1LT60l/AiFnUIcjruiWuUKGboqLxHs6fQ LkgWYtOBkOJIgpKjkBN+CJq76uYrb/6AVTFLXWlSuHa3i6ycpNRQ3nYAUXOznGXeGnKq fpLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728777694; x=1729382494; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=t9VcveGu/NxOxTj5bcGe4vOOsa1lkuLS/Vumxvc23Qk=; b=G5fprH9DqCQaRKHZiR4FW/9PBwKS2egON1Krwup2bvQ8gOix9Ok4VcLAiQ5EoV6VGO e89lLzlGDqjGeSXRg3enKBwMohaAPJ6WaMl6n6EXUbk+NXC/Fozq4vGkkwfu/MET5pJs da7V6WpS6ZXtaxacY4R4GYJL6ULkCw/yqIitaUlB9mdA45FXNuLnqV0o7ah0sDnEz+lO 3bwAlWArULwvE/lgRyAarVgfnJWRok96sUdk8pnAstXcWNqsEvyN5m6rZl/DKDDONB7o HN5p+pXc6yx6T27GxOa5raEUbO9pFXv5jLrKyuKmu+41UDcOtQflQc0r7MNrmCWBAzPi kRaQ== X-Forwarded-Encrypted: i=1; AJvYcCUx45j88lQD/0/mxtfOnzEio82zVaAHP6OkvkXpZXQ9Dk1NVPzgQXHncCBff/UWRe5qTAQzG2EHnAgc@lists.postgresql.org X-Gm-Message-State: AOJu0YyC5Qtp2pnsybsWnQNRQYiCnq23I2J07h7O4mf2mNyLhbieISHk pkY/t+7JjmYRxfGPWcAdB3slP13zxm68B4KoPOmIilQ4ZtxACf3E X-Google-Smtp-Source: AGHT+IGHQ3iCP8RrHoPDkw4Ombhx6VjkfMNARnIv48POs/ee3befhED9GlBlzb+e9/3FQoIKHlM8GA== X-Received: by 2002:a17:903:2309:b0:20b:6f02:b4e5 with SMTP id d9443c01a7336-20ca13f727dmr105279005ad.9.1728777693706; Sat, 12 Oct 2024 17:01:33 -0700 (PDT) Received: from [192.168.1.36] (ppp-124-122-35-125.revip2.asianet.co.th. [124.122.35.125]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-20c8c212c22sm42303215ad.186.2024.10.12.17.01.31 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 12 Oct 2024 17:01:32 -0700 (PDT) Message-ID: Date: Sun, 13 Oct 2024 07:01:29 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Question of Parallel Hash Join on TPC-H Benchmark To: Ba Jinsheng Cc: Tomas Vondra , Zhang Mingli , "pgsql-bugs@lists.postgresql.org" References: <20f9671d-6f40-429b-a749-a2f53086e0dd@vondra.me> <3c7df680-97e6-4f20-ab27-65fb8282f95e@Spark> <978176f8-14a5-4f4d-8925-07d2e7dec4ce@gmail.com> Content-Language: en-US From: Andrei Lepikhov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 13/10/2024 01:11, Ba Jinsheng wrote: > I changed the code to generate an efficient query plan (only the > HashJoin in fifth line is in parallel), so I am wondering whether it is > possible to optimize the code to enable this efficient query plan in > default? I believe at least, it would improve the performance of > PostgreSQL on the standard benchmark TPC-H. > If you need, I can provide my environment in docker for your analysis. Thanks for sharing the case! I will investigate it in a while. -- regards, Andrei Lepikhov