Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jCjcW-0006nx-Vo for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2020 12:40:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jCjcV-0004BY-RB for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2020 12:40:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jCjcV-0004Ay-By for pgsql-hackers@lists.postgresql.org; Fri, 13 Mar 2020 12:40:55 +0000 Received: from mail-pj1-x1043.google.com ([2607:f8b0:4864:20::1043]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jCjcS-0000Xm-45 for pgsql-hackers@postgresql.org; Fri, 13 Mar 2020 12:40:53 +0000 Received: by mail-pj1-x1043.google.com with SMTP id np16so4102114pjb.4 for ; Fri, 13 Mar 2020 05:40:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=xc+O4HZOHu+HUdt/jBJWFrlFOtVPm1LAZ3qAvmsA448=; b=UkNiNzeW+KnpF8TZxJR8n5m0epkZYKHytrV1x7rkPe/Ntn8Zsd3sRQyJZm+bZnkyEh 1zLTjYj4+bTyYFioeBa6/YVaxiFO0tpxvBV8I0IGWqpGfmMI2Hil/DqX0tIHrJDmtzIg 9uLBytqcOsBjqpq612/Jq7ecbm4RHbhCSCgt8K4BSxDH29jDC0WXixztoFKHJD+7KwSB rmDLG/SJc2T0DRY1Aht1TOUHzag1vu4DhP/82wc4cd0sbcN3AENQBSjNkradhjO0/M8D uRY5dXD/mYLL/j1a1UWHi3g6ZaPI1d2epylrBAkMmUabzwCe9gT/u06bEt8qLq5xkGZa vu3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=xc+O4HZOHu+HUdt/jBJWFrlFOtVPm1LAZ3qAvmsA448=; b=lwPZvOMwLL9wvRS3CjVfYwRmAwvwj2zgLlLymUV1eutOzrUKckTsk1HL+iOOP8ynht JuxixfgcJ3+c7hJsT8oas9pzMfidPxj5EmUdij02CQNetGTiKq8pREYo/UkSYTXJLGbw UxD3shphoByhPl9gbu+3Qb3+AlCErLv7EGfRRcbwYemqwKEP2B9qWqQnNoRSp7bv5wCk xnhf7gjR42EUkz+AS4dCVZ5aUFAE42fa7+RWlfMY9i/3P5D570DJkSv22DRdfqYxPlJ7 Ub/PdENCsn0FXsLyBsLebzhF3z2F25U3bCZcwMH6z5E2OQmM2wR1rQgDGV9AD2KAY7WJ sgpA== X-Gm-Message-State: ANhLgQ3oOTID5nrQnTUUgmoNrsbCYFk6vDxkEplIZgk5coGx5VA3Ngdx fn1Ow3h5W9IqBehaaq1Is1sqI/npibnfEBIHIUeMkj79OsiQPv4zPaDUzPMNc5InWjiNszHyUO6 JxRwOl8/kj4ToRlubl1MovPBscHkzLnKlmvafEOpZsDbaIuzeWVTT3TH3P7TFpqGWvv19yXlYcj SVk1IZCCYf/9zdG1cTf6ZwyxlsqqLFUg== X-Google-Smtp-Source: ADFU+vtFwiCGLYJQ0FEo7a89DTwMewMS7LUYYdJlKK597Xqo4KXGJutRzBHmOK6k8S3GdZfmvRmRQw== X-Received: by 2002:a17:902:6bc3:: with SMTP id m3mr13417529plt.27.1584103250632; Fri, 13 Mar 2020 05:40:50 -0700 (PDT) Received: from localhost.localdomain ([157.33.236.190]) by smtp.gmail.com with ESMTPSA id y18sm56409434pfe.19.2020.03.13.05.40.43 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 13 Mar 2020 05:40:49 -0700 (PDT) Subject: Re: [Proposal] Global temporary tables To: =?UTF-8?B?5pu+5paH5peMKOS5ieS7jik=?= Cc: Prabhat Sahu , Pavel Stehule , Robert Haas , Tomas Vondra , Konstantin Knizhnik , PostgreSQL Hackers , =?UTF-8?B?6JSh5p2+6Zyy?= =?UTF-8?B?KOWtkOWYiSk=?= , "Cai, Le" , =?UTF-8?B?6JCn5bCR6IGqKOmTgeW6tSk=?= References: <24099f4e-742c-e92b-729c-77bac1ca80d4@postgrespro.ru> <35A2DF75-05A8-4F8D-9D43-A930E2ABDFDD@alibaba-inc.com> <82851B35-E2FB-4A5D-AF35-A2B5023DB9F2@alibaba-inc.com> <77320A29-DC39-4EFE-A5E2-0A00F6A316E8@alibaba-inc.com> <7eb93026-0f35-325a-132f-ca183a5da3ac@enterprisedb.com> <7CCE7DE5-5E85-4155-9010-5EDEAE762194@alibaba-inc.com> <087bd809-e1d7-ee44-da1f-25996abad442@enterprisedb.com> <40391A22-CB8B-4143-B936-7707667F7905@alibaba-inc.com> From: tushar Message-ID: <649a795a-49ef-ba06-dfca-68f423fcf13a@enterprisedb.com> Date: Fri, 13 Mar 2020 18:10:42 +0530 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.9.0 MIME-Version: 1.0 In-Reply-To: <40391A22-CB8B-4143-B936-7707667F7905@alibaba-inc.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-CLOUD-SEC-AV-Info: edb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 3/9/20 10:01 PM, 曾文旌(义从) wrote: > Fixed in global_temporary_table_v18-pg13.patch. Thanks Wenjing. I am getting this error  "ERROR:  could not open file "base/13589/t3_16440": No such file or directory" if max_active_global_temporary_table set to 0 Please refer this scenario - postgres=# create global temp table  tab1 (n int ) with ( on_commit_delete_rows='true'); CREATE TABLE postgres=# insert into tab1 values (1); INSERT 0 1 postgres=# select * from tab1;  n --- (0 rows) postgres=# alter system set max_active_global_temporary_table=0; ALTER SYSTEM postgres=# \q [tushar@localhost bin]$ ./pg_ctl -D data/ restart -c -l logs123 waiting for server to start.... done server started [tushar@localhost bin]$ ./psql postgres psql (13devel) Type "help" for help. postgres=# insert into tab1 values (1); ERROR:  could not open file "base/13589/t3_16440": No such file or directory postgres=# -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company