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 1jMVef-0006yX-Ei for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2020 11:47:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jMVed-00034c-HN for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2020 11:47:31 +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 1jMVed-00034V-5f for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2020 11:47:31 +0000 Received: from mail-lf1-x144.google.com ([2a00:1450:4864:20::144]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jMVeZ-0003Re-S1 for pgsql-hackers@postgresql.org; Thu, 09 Apr 2020 11:47:30 +0000 Received: by mail-lf1-x144.google.com with SMTP id r17so7674488lff.2 for ; Thu, 09 Apr 2020 04:47:27 -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=+6APzIVVwwPVSKzeLhe+/QIWbxy9mczaFSICASBUmx0=; b=q9MPXybG3Yg6n4SeoPCmag0Yu6DL5FJZliS4Zivof1UO3moUtO3FBdHmXUXdq3zjA9 Vw2GvllLN5gVBIeb6woXyF/75S3MKd2j/lntdK7//bvw7c7lC54ynwMRE+FfzfbLqR8+ ze/xc+Z17+l81wexbgsT0JtlgwQkAcsF1m/92yt2YX4xkia/dyWINRIxBvD+rtFTn2om CX+LveE4RZSnDgrBv7JZi+GIDoIoQSZB17bK3QGPPO+sRUiidIJ5VUuLSjfxSFVAV+eH +47k+Ak4lLwvyKsc4cTn3Z59LQJ7uO21fccKvoM4nFs+lX5kzDP5+1PNo+O/rrRY/hee xPVw== 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=+6APzIVVwwPVSKzeLhe+/QIWbxy9mczaFSICASBUmx0=; b=Jw93JWFEsrwcgyrg+LLbTkPUFiJsV6qv9iuLuFSZWwrl2P0sO8EnjtSzI92Rtb9z9Y SpxWbrppxPbO2koCx9CDSd7ZnoblZba/Yqf5kYtywlPP3pnVmyOBXYsDReWFUs1I6XeJ RRsa4J2MSsfO43ZVAoCxLigGKupoVmHkTw3+696m9Q/0D88fASyBkpDrjEgz05OtRQrR siaQB8fD/jsSe5w+0VrOUnUYxb32Q2LTVGosRCAUYt9sXVt4wY3LLElOfDQjja/LkSuW cJCujQ/JRHlaa45BXfcf5bNZza4PZBSzT7+fkO4cQHMbdWgZ/udyK/4+U6JhDCmAktRE FkmA== X-Gm-Message-State: AGi0PuaHkV0BFFae+Zn0KT7TFEXuxVbv5l+VuRoZd2qX3mla4jPy46A7 hE4hfYIYXx4WeDP7xyD7k+tFHjN3GQ19el3f+TKN7YLI+z+xLBZt+I0nzni55kOrvF6CxKNTejm oWblzhOZiVf3iKvmMLMZ5oHjhdU01jwdxr9ZsWTWCNp+qtAXqwRk2Qr1GwMkAfrRc75amaycfkv /HydZ4bNqwKqnFJo8tDcqPnmocrmbcpQ== X-Google-Smtp-Source: APiQypLBBn8mnP09lKPP+/D+LcyNmQ1uO/vlIudATpjqfgUW3eSqG6SPkYiq4o+S1tSKbaaEBO6MOA== X-Received: by 2002:ac2:4832:: with SMTP id 18mr4256139lft.162.1586432845740; Thu, 09 Apr 2020 04:47:25 -0700 (PDT) Received: from localhost.localdomain ([157.33.226.184]) by smtp.gmail.com with ESMTPSA id b2sm18396118ljp.63.2020.04.09.04.47.02 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 09 Apr 2020 04:47:25 -0700 (PDT) Subject: Re: [Proposal] Global temporary tables To: =?UTF-8?B?5pu+5paH5peM?= , Pavel Stehule , Robert Haas , Prabhat Sahu Cc: 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> <0498c45c-53cb-d9b0-c1e2-7d2d1a618511@postgrespro.ru> <20200109164829.mdl3z5xalmaqxs67@development> <3fef844f-0e73-8fcb-e4b6-595d6317b191@postgrespro.ru> <20200112015109.caab6qdr2ob6d5jv@development> <9262B679-EA73-495E-82A6-508F5625023F@alibaba-inc.com> <8517A6EA-17A6-4160-8987-B01073A0ECAF@alibaba-inc.com> <8BC7841E-3B32-4518-9586-D9ED571F4922@alibaba-inc.com> From: tushar Message-ID: <6bdbb029-494c-bd16-8bc3-391cf33674c6@enterprisedb.com> Date: Thu, 9 Apr 2020 17:16:53 +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: 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 4/7/20 2:27 PM, 曾文旌 wrote: > Vacuum full GTT, cluster GTT is already > supported in global_temporary_table_v24-pg13.patch. Hi Wenjing, Please refer this scenario , where reindex   message is not coming next time ( after reconnecting to database) for GTT A) --normal table postgres=# create table nt(n int primary key); CREATE TABLE --GTT table postgres=# create global temp table gtt(n int primary key); CREATE TABLE B) --Reindex  , normal table postgres=# REINDEX (VERBOSE) TABLE  nt; INFO:  index "nt_pkey" was reindexed DETAIL:  CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s REINDEX --reindex GTT table postgres=# REINDEX (VERBOSE) TABLE  gtt; INFO:  index "gtt_pkey" was reindexed DETAIL:  CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s REINDEX C) --Reconnect  to database postgres=# \c You are now connected to database "postgres" as user "tushar". D) again perform step B) postgres=# REINDEX (VERBOSE) TABLE  nt; INFO:  index "nt_pkey" was reindexed DETAIL:  CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s REINDEX postgres=# REINDEX (VERBOSE) TABLE  gtt;   <-- message  not coming REINDEX -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company