Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bZoLy-0002dp-ND for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Aug 2016 00:05:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bZoLy-0007QO-4I for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Aug 2016 00:05:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bZoKZ-0005st-OV for pgsql-hackers@postgresql.org; Wed, 17 Aug 2016 00:03:39 +0000 Received: from mail-by2nam03on0083.outbound.protection.outlook.com ([104.47.42.83] helo=NAM03-BY2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bZoKU-0001tE-3N for pgsql-hackers@postgresql.org; Wed, 17 Aug 2016 00:03:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=uby5bQxA4gPquo4NI6Wj82w7eJRAEk3BNytOo3XZUP4=; b=IxYwD6hXKkJRa/dnyi7saiXmqTL+gWN0L3L3K+kwiz0zr8XU4WW+FovgnQM/XXQyxhpY372q6vSc5na/HzLiEXB5GaLXK0U5ttArrcSG8t8j2nD1RJR40RBy5TXOsvkugp2Z5qiiRyNAl9Clu3FdEZH679DjoGjTe0U2qckHIt0= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.local (70.113.16.71) by MWHPR11MB1646.namprd11.prod.outlook.com (10.172.55.11) with Microsoft SMTP Server (version=TLS1_0, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA_P384) id 15.1.549.15; Wed, 17 Aug 2016 00:03:27 +0000 Subject: Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables) To: Robert Haas , Aleksander Alekseev References: <20160801124531.66cde374@fujitsu> <26c3bc60-6613-e7ab-517a-53136f01fb6c@2ndquadrant.com> <13191.1470072250@sss.pgh.pa.us> <20160804151451.6fb87507@fujitsu> <14212.1470595566@sss.pgh.pa.us> <20160815005755.gswdyjfob7dzw4yp@alap3.anarazel.de> <20319.1471223097@sss.pgh.pa.us> <20160815010852.5ijua2wm2edzimd4@alap3.anarazel.de> <20160815121216.46bd758d@e733> CC: PostgreSQL Hackers From: Jim Nasby Message-ID: <95bdc353-1a89-3fe3-1181-eba558c4df83@BlueTreble.com> Date: Tue, 16 Aug 2016 19:03:22 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [70.113.16.71] X-ClientProxiedBy: BN6PR08CA0055.namprd08.prod.outlook.com (10.172.144.17) To MWHPR11MB1646.namprd11.prod.outlook.com (10.172.55.11) X-MS-Office365-Filtering-Correlation-Id: 027e9ffb-ccbd-4543-a9d8-08d3c631eae5 X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;2:gtyzHeWufFGx2e2vg2+aZL2OYG5uMNoGGUMM7JWYy3T7jCZ3mJrCFrj38OZXs5AW65vE4MTioQpYHrac4PQm9o/4P6OzwyCCaeTIG+7eGWX0TGsOV9W7exwGFa2+Y9MqBgmLYn4hTB6dA+16fdWae2fJRhuqbL200iCBIUOj4l7faEbD+aE4lZLmWr9aErzM;3:7qDRQNt+ttzpTsx7WtuLPAEa1WI18EF1DmZJlC8rlLZgoWugnHqDDyGqkGF4rRnZzH1mB+sCa9eI+o3F/4ERDk3qgr3Mu8gYbIVtYHZ2Bm5/KM5asxqTdJbjmK0JFIuE X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:MWHPR11MB1646; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;25:x4bTwi8VxpA4xLLQvr2eukBc/D5vwRQTwYthwl4IVPPYvDJPxsJuueTxwo9Wx3VsdlVbwY6a9exeiSRgf12BMQjJ1+YJH6jwX9ZHbQvIJL6VCiMAYpA2FSGUAONKCqdcy3IoDg80az8c6a7k/zn5qFdgT4b1veECtbs0E0swuiOBcP69UPxQm2v0OtyIleumFT7wd6JFsi6Xt4Zhqw5OFYRHnJZMkAjsrRE7lyMkv9rerg/BjUZyGaJHX2sj1MKOJpDwsspqw+9eRru2e/s3IsQqWaM784g2KAI2i5XP7O5cIFmFqoh4Lh1BfbyaO8j3c4INAB7X98oNobdAZNQNlPa34DsPr8DzHcCFLQtcNXxxU6my6hmoFWdQXs4Zyh9SOZmoZdfc3CDjJLsdCDeNHVMNx6E9NWs1rMZsmJ4ne19tyBVzKhMGkJ2e+4SzM3JMG8Dw3LrrA/qzgRmG5fvVi8/I67xsuV61lhA0rvRviT9Tp54drec/9AZ2TuysEjRjM7CgmTOE3mAHhALRLdZuGqXmESFolYdFJLyZnJND4vWz/hI7ZNN8XyPmG8QG70e/OrhgHUtbCuRtXq60z8W7TOmk17XGl2f6uCJBGSXJVpGwGESMgV5hlT987NtABxWiba2bg8VCgiF3gf8K3N7qdf0q5sSH7Tcgc+xD1SGPX5I3OgKf/tg0NVcrFZxTYnBLGeSxmnVY5Lf5yOIElHxFryt9pCe2lcBz7WA7zFPBlFLnVC8Pd10RI/ixzoUJj3Q2m039TD7t65UNROSa3DZC29pC2+60kUcYe485cLzpu84= X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;31:aix1CeleOsygORXOd/IV645KKsH36tkbltKwd3DMOrjPeT9j8ksxEXi9ltJOegXT/DU1pGLp6EbUWbxHsY3Jql4jx7hlzLZSynals9AXw75nNXae22Py3LZjzM7lTInH/+J+FPGysLBGIUZaG5Kwxa2LjAEPqLjdx9TVogfoGN+RIgUT47Ukdhnb9HOzLion5tvrRMwBeTFddmLoht9Fb03NQnpSoPxloDdNwvqreUM=;4:KQgAy/DU1emtfsaETKRGTY/HvnmP7yJiBDh8I8a2wwApqyCis3Nk/ii58bKR1frPWBueniZhijngVae9QxP3B+MG4HjBhpMJBIHgzLRt7sjono2XckPv3OIS8QhMUS1khtzblh7jxbM2PRGbomGsaoaBijoPyKx/e8Y7AV3SAgPZ3wGnxYGPhcok6vsLg1iWIvDbRztCn5Vmg3UwNSLJ+KgXa0lw7a+3FN/1EUaHVAkInhPcmbuMlo8BKtaLJgQGSYy+OPLCzll+/vlIIa8gJeN6DBdadno4HLBlPc9yrujQTQYj7muwjldmcLs78CPykDaI+8+umw7sxGB6N89nsCImq+0zt0hmxj4WP9vIBqd3XKEmRYJO6KxcQQ8f/wr+ZpT5GC7Gx1eN7ZwbDuNpjzWVg3q2BVW0oi8IkGjOe8M= X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040176)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6043046)(6042046);SRVR:MWHPR11MB1646;BCL:0;PCL:0;RULEID:;SRVR:MWHPR11MB1646; X-Forefront-PRVS: 0037FD6480 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(199003)(24454002)(377454003)(189002)(50466002)(6116002)(15975445007)(4326007)(3846002)(586003)(93886004)(16601075003)(230700001)(2906002)(31696002)(97736004)(4001350100001)(189998001)(2950100001)(19580395003)(47776003)(106356001)(8676002)(7846002)(31686004)(7736002)(81156014)(66066001)(50986999)(81166006)(23676002)(65806001)(105586002)(76176999)(305945005)(54356999)(92566002)(65956001)(86362001)(5001770100001)(42186005)(77096005)(101416001)(33646002)(64126003)(68736007)(83506001)(36756003)(65826006)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:MWHPR11MB1646;H:decina.local;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtNV0hQUjExTUIxNjQ2OzIzOmVlaEpKWTlPK3loMnNFTitzeS9HbFpLZlFU?= =?utf-8?B?NzJyZHFpckppQ3JYWFgwSjNMWUlSZkNobjM0U3laWi95dnlhaWV3VGpZZGpo?= =?utf-8?B?RU95V25DdGllM0Q3WUlqbE8yMm1zODNEdEtuNHc1SGJXS3hpaUlyYTZ4L2tE?= =?utf-8?B?VDV2NERJZUpRYkxwQWVkS2ZYN0xLLzZvSzIyY1VWRHFCTTBkU2lubTUvc1Nh?= =?utf-8?B?dWdHcUFPb3liVzgrTnVzN2JWUVNCUk9GdldsL3ZSb2tKSytzVmFveHRsTyth?= =?utf-8?B?eFl6WVFjUEJ5VmgzS05Fa0pBYUM1eW5pSkdneklGWHpmT2ZDeldCaWtpeG1C?= =?utf-8?B?Zitwb3Bsc0REZXQ1bHJRc1dyTGJCSDdDZ294WlhaVjM4dUg0alkwWU12eFZO?= =?utf-8?B?RFpmbG41MnVqT3dYU3o5em9ZUmpyVFU4bTJSanAyaE5rMmU4cFlVSmc4b3BF?= =?utf-8?B?WGpoUXcxMmlBck8wTFZ1NnQvNUR6ZWhtNWtjQnpYdzVtK2gxWllJcVl4WXdS?= =?utf-8?B?S0hZMG9VNFBjNjE5UGFwd3N1V2pVaXhOdkYwc09uOXN6MWNBa2EvVkRJSFk4?= =?utf-8?B?dWVPZ3ZqekJLMWxlOExWRG5UaXJ4cmQxTDB2ZldTL05ONXp5bnZwWk5lbzJR?= =?utf-8?B?OUhJeUhDbU9VVFNrODlSR2kya1phWnFOVmtRc016RXRxWlpFUkQ0L1FBTjJo?= =?utf-8?B?REZQcVFRRkRpa0lMK3Q0WFpxZzl3VS9aZGs3ak9oQ3dzd3cyZkpsYTNGUXkr?= =?utf-8?B?Wm13amNwS2ZvYjQ2dW80Z241OFNnS05xNlB2c2xQVE8xVksrdS9ZYUtyVWZB?= =?utf-8?B?cXBYZmNIRWV3Mnc3RDdQeG1pcm5XRUduRnAyQjhvZDlveEN0OUgyQ0ZlcWFq?= =?utf-8?B?WmFaT1I2dUcvbGwrRWI1bXBlcGd5bnhBKzN3NFZmWmxrQzdIS1h4Mk1YYzBa?= =?utf-8?B?TWl3bDQ4NmdHMFh2YkpKaU5zQ09HVHh5d1pTUUkwY3JHQ3BJcWN5VHZIdVNz?= =?utf-8?B?MDMxdFI1ZzR2MGhmUHprVlZRTUc1ckxIZmNDRWFrSk9qTGtyK1FETkxRNUVX?= =?utf-8?B?VzdNOG0wQ1FCcmVtOXlrbG15clZUNGxqOThoSnhLYmt3SS8yVUVBOHU3MURB?= =?utf-8?B?VHZaRnBqS2tnUVVwMHBpV0VmTEhNVjBtZ3cvZnZsaGlaZjk0WCtNWlM1bmU2?= =?utf-8?B?NHhVK1Q5L3J3SklINGtkSWcyNnA0MVpLU3pMMTRtVlVVUVBhL1IrRU5ZdFNW?= =?utf-8?B?akZJalpIRTNQZzdNaEQ3eFBGN2JVMm9IaHJDNE81amxKcllUMXBiUFZqNVNq?= =?utf-8?B?RFg2S3JQcVNWZzE1WFRrN3J3SDduOThSTE40K3gxc3ZXbkVrelhJeFRYL2VH?= =?utf-8?B?OGJxRnVtOStIeWhFYndNdnlrLy8zUjlmVGdYbUF1cjBwMDIxNURldWpnenRX?= =?utf-8?B?N1FWeG9vcG9GU1F0b05NbkFZL2FnMGV0Q3RxNTJSWDdubTR3Yi9CSGxvV0tT?= =?utf-8?B?NUJUTkJzbksvdGJZM0IwZ0poRWpWWGJkeGFqVjc3Nlo1Zk5TdG50NDlaWml0?= =?utf-8?B?STJQUkY5YS9rTm4xT1RCRkFyYVlNdDZYOUc0R3lqTjZkT1B5bVZPVjVPK0R5?= =?utf-8?B?YThsVmNXOE9lNVZLTjIwRm5xYmpMcVRIQnZvUUc4VWRTY1lLV2xsQ0hLVjdI?= =?utf-8?B?emdSam53T3lrVHZhdGlLODIweDZ6Z2xhL0xlRmRWNE1IbXpTaDZRcmIyWGhl?= =?utf-8?B?WXJrTnhzZjZRMmdwV3FsMm0yTVp1emlNVlYzbWx1SzBnSitMQkRrMXVFenR5?= =?utf-8?Q?CbW3I9ixq5jTb?= X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;6:Tlh0M4uTW18r+EjMoKpNf+HZiXMcCkTCSCIef2Pn6kch/Yc5n7zXpFjZTCehmRwg/mp2hV8TbCX3T9U+vFkXSGC9ZF6UxImEkaRUJLb/zDC+ChVZn6e5PSLa307rj1lX0xE3MxxGLEaJ3Vj+yciCT+CoknG0igIvyFdKFPiFynmDuchv7JbBt5UtO6nUHId/yhISrWPAWPRKbCyRAZld3MjxxnnfNd9Ixrk1a1tN/00FoRZNGESrh3IOF7RyfbJoClHom2Qvgq+AujtvOFALeFX2rrEI+EEATXeY3y3E8c14SeaLSudkZn5iSkTCsMop;5:9oJ62xeAbTFytUI7yzSMBtXniIE/MVGdWj10gTwjzj4C+W4DMbS2J7cCiPVonw8HpM3JrXgOSlo5YMQ5LegdnJ1ZXJ91v4VCvvo4uQQIGqOfMp2mN0pFRul3D1Vsk5NvpUxpjjnzro6BcAodr+cqcQ==;24:h450x3AUvm8FbNCOqj32Lijs/kbH6kiGhWfqwdU9vyxe8wcK/rOBS+Wqz2vbCu1qRWD6FxAMJuual4DIkGXC45sYTayw3KS3hRK/tFxz1JM=;7:FNjS75oakfZkf3pgzKr7uKY/db6p/WfMe211drAFVoNPL2PSYcfXgJwaAxn5zYSSxdaJFKFnTnu6Bz+o6anSq807w+fAwxiOZN9166jZ4KCC1YOoAzY9l404JTteo8hpCx6vIGhMyqokwe4D6L08bTsbQYj/r5382xALfNGGHm03fJUuIjKLxgq+WcQZ3tApmBtUA5ddiv3Nlabk2cNVQm5/WNKBwV7aqaAQhaTXE7e5DKoDZA0ckT5S65wsxIl/ SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 17 Aug 2016 00:03:27.9803 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR11MB1646 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 8/16/16 11:59 AM, Robert Haas wrote: ... > That doesn't really solve the problem, because OTHER backends won't be > able to see them. So, if I create a fast temporary table in one > session that depends on a permanent object, some other session can > drop the permanent object. If there were REAL catalog entries, that > wouldn't work, because the other session would see the dependency. Some discussion about TEMP functions is happening on -general right now, and there's other things where temp objects are good to have, so it'd be nice to have a more generic fix for this stuff. Is the idea of "partitioning" the catalogs to store temp objects separate from permanent fatally flawed? -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers