Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bhJ9j-0006bZ-F9 for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Sep 2016 16:23:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bhJ9j-0005QR-1c for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Sep 2016 16:23:27 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bhJ8J-0002IX-Kz for pgsql-hackers@postgresql.org; Tue, 06 Sep 2016 16:21:59 +0000 Received: from mail-dm3nam03on0085.outbound.protection.outlook.com ([104.47.41.85] helo=NAM03-DM3-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bhJ8G-0006Hg-NX for pgsql-hackers@postgresql.org; Tue, 06 Sep 2016 16:21:58 +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=u2zukjKLG2jDwOJAQRDmHtM4baiKWiHo6s+YShqeF2Q=; b=Qit6mjOxHs3q7KPTFevwvXGpkLplkQ7oJRa2nO+jhiHoR7la+mDAxj19bssaCfCd3ZxG3JlG9eAYAnW1n7ZHJguVuIwFLPQ94uaPsBDmHU3pXNxb7Wt8lWy7vxGTszQkzY8OuiiiF8AwP2nSRPDT36ucXIGe7n/CVPFjVNI6vvc= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.local (70.113.16.71) by DM5PR11MB1644.namprd11.prod.outlook.com (10.172.38.15) with Microsoft SMTP Server (version=TLS1_0, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA_P384) id 15.1.609.9; Tue, 6 Sep 2016 16:21:53 +0000 Subject: Re: Fun fact about autovacuum and orphan temp tables To: Bruce Momjian , Alvaro Herrera References: <5b48a2e8-571a-d24f-6a4a-cd5744e6f1dc@postgrespro.ru> <20160905154832.GA681833@alvherre.pgsql> <20160905171454.GC13538@momjian.us> CC: Grigory Smolkin , From: Jim Nasby Message-ID: Date: Tue, 6 Sep 2016 11:21:39 -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: <20160905171454.GC13538@momjian.us> Content-Type: text/plain; charset="windows-1252"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [70.113.16.71] X-ClientProxiedBy: DM5PR09CA0045.namprd09.prod.outlook.com (10.172.184.159) To DM5PR11MB1644.namprd11.prod.outlook.com (10.172.38.15) X-MS-Office365-Filtering-Correlation-Id: bbf42b03-7ed0-4194-2eea-08d3d671eaf8 X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1644;2:ZsoYjKIrVsZxMVPyevVtE7jO5ly8K103U0vQV4gt6yumEwU/k5xdehy8SrdriCcR2qY0AWjR9u1PJqXgkcIuor9/SODUulDagUNM7FZbvAa1hpdqjojXucgHBP4kLyi0N/3s6XCU5WK9MzI17riVOPhq549PBnNaxfOncUNdmEsXrn65iQODlIT7nhuGdZ5b;3:WJ7cR0GYro+FCOV3hjU7EMgi1CqGLMuuyS2i9X+eytpR1qTfr9wbiCpN77F4VUpEGgGxDPymG0HDE0M2lueohNoqc4nnZnUCviNVN2ewqg8IDVLvZW6SJIvQSCnDsaJf X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:DM5PR11MB1644; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1644;25:EM2Wb7mI4VGG/fd/ntOVqsVsDkiAqwUt7nI13EkrSSt4A8N7911rd1qqkm9D8dcmywJFSFe+PgqFwCCiToTJrpoWK8JhonLI7OvQ0u7MXv0euHk44brKSy/8kwSMmmoN0w8JixjWOL1CJ+b7nwhMMy7NntKUSloTjbmUZsR2UC+c8Bsfg/Rqc/UF+9l+k2KEfCzU53xC6LcKpfiBS6OhYi2r/Cw7//TVKtFQlm84r5fxS9RjSSLaa39XThNF1EzNAv4kuzSINKgfL21Ayf7jlEuqrP6R2LT5JlAreXFjb50MZXvGeVfug81P4oyki4QYTRRT9H+MLlSfr3plDyFQTlvLfTdidAJ+3c4qbiUusKcTsYXhwuBAGWlrnLg2WgxAT0zCe2Rj6LC+q5t18NFS+LgIcFBVVs39LMpbvRfwvVFD1iRCLFWjT0psMTWdurDwBR/CmdAr/rUC6uDhP9ir6egm343V43BW9bLwu+gfLW1PXNV73NiqV55UIeGiQx3j9bn3ELFL5E9e9PN93Ox1f+wHN13+k4tvNTm5UZFNNkGbWoa5XPYgcskH+dnRRgPN+7XgYXcl88SV0mMmmNr6rKHyJ24NvPpFkYc7ZzwSxEPE6pRPdfw2gu8fbzWBKS/Rq0OEgXifXhLvPdPmxAtzlR+9I8Y22XAWy8pMeAICKt/zkXUxWcFKESEdoRCiP1/iigwosy2QbcS/UT17aWndsBuvCYEB7JFbPYNSdTm4zd5we84VpFpDTOUiOEEGLOdOIZ3+bcTEnnin8/umpYtmd+kHOIitC6kI/e8grpv8j1J7DIiBMZRusedqjhESjZqt X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1644;31:HNt7Z2L7iVRp9GDbst3W6qvwixX6gwkF8inNh+YgsBIz3s8XuUcVCyVpHvX3H0ZWuViQNY6NUJl+KvJaWcUP0bEgoEGa0cxEtHW2KuqF+0nRmBIH8wHBvGfwfJAqdRdA7l7KeJf97bZWbEiJvWaoJym/9MPgIemf8LX15m4su3zI2KPWL0I5BphVW+KNNJRu0HX+WNuu8MV1Qs/hCkA9y6wmJvbbrZ/fGkjOe0V8kt4=;4:CG9wS4ws5/gveXsbnOsk+s0LK08On48R2EmjwV/0z7nPN2V4ucpdDh4jQ1miiYVldtLO7wDA8LAml+S7v1rIjiUcgy8zt/8GdG5hdGarZ+DAvOLFn4qE2A2U7sZU5L6JGwszQQ1tZhFCiFr4QwVH9gx6lK0WxVEZpKYFuF3i10Ib1ymNW52JjWvD1Yxh80GFuB877cSlDbzutadB1fV8XgVbT8nE7auryJj04LS8a0kSfVHfVBu8D9QPUVKbUKCHDmiVB6Bi8/rX/zszfHIeJbodYqgfvqx86WdPIIlnl/fOm7JX/Q/u8ryc3darsksoKwXIMu+v0Zg78vIe8FWGMSRJF+lvjsWle3nMotayepow4k12CHryZ+6Z3+S5JELfe7xuX4IDQ6QE2EmCY5WexX9sLDuAhCRM61nG0pSxy9U= 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)(10201501046)(3002001)(6043046)(6042046);SRVR:DM5PR11MB1644;BCL:0;PCL:0;RULEID:;SRVR:DM5PR11MB1644; X-Forefront-PRVS: 0057EE387C X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(377454003)(24454002)(189002)(199003)(36756003)(230700001)(92566002)(189998001)(47776003)(6116002)(76176999)(65806001)(19580395003)(16601075003)(65956001)(66066001)(31696002)(105586002)(65826007)(68736007)(2950100001)(586003)(106356001)(81166006)(42186005)(81156014)(15975445007)(31686004)(7846002)(7736002)(64126003)(8676002)(77096005)(5660300001)(86362001)(305945005)(50986999)(54356999)(3846002)(101416001)(23746002)(50466002)(33646002)(5001770100001)(2906002)(97736004)(4326007)(83506001)(4001350100001)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:DM5PR11MB1644;H:decina.local;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?Windows-1252?Q?1;DM5PR11MB1644;23:oX5QDvRRnaX/AtlrxgqNvZF6t8vtlJMr0ijU4?= =?Windows-1252?Q?00WRW9dhsWRXu8Z9YThkLQD0sQo7V6eN5EDOp3exRWuB9Jw90zHvzHc4?= =?Windows-1252?Q?ug4lcFCaF5V/kEga87IZLXRvvsSiqZ+DjlyYira2ggYiCHTtK70FwVro?= =?Windows-1252?Q?bmpiZ/P9I3PUXW45qbAlpE19X/eHKOjFDXzbNKQDvdwtJQJ3pv03qsyR?= =?Windows-1252?Q?zkkFi8oXF0LXjsog+HXJlUUQyVh+1OObBDj48+0Y+0YVDF0Cpv/bhTp2?= =?Windows-1252?Q?paGNTDcebaS+RT+f9CF24kohAjn2t6vevRD1w5zG3r5biIy0/VAR3kNF?= =?Windows-1252?Q?9ahsUoL+7i3vlz4oEVXJbLMH9aJOcMg7NM8jNbETxwQingshoRS1Hnai?= =?Windows-1252?Q?PmV7dFVuUFBoAPLRdQcKYMQc/HfKVRqg8Rpq9+zBlFJKqHKRbrvXBMXg?= =?Windows-1252?Q?d8vrjYxS4Dhj1uZ3SVPioacThaDmkSCze+3uJrg4ZuNh+ZpOKGYBbEaJ?= =?Windows-1252?Q?He9bCFhms7qMYwcTzfIypph6P0eFwUxKIh5/2EKDKAx5DqeqW1V8X1Np?= =?Windows-1252?Q?JOU2jyTqJqmZtMY+hjAYVByCl2jqf9bGw7+iJkMFSP1gaC2Vx8ZTLwQJ?= =?Windows-1252?Q?Ey+xXyo70DxD/tkkRKkSPNYtZcpZbpVaTMUZAyV58xb++BehiJpryVx2?= =?Windows-1252?Q?iBNyH3JkWHxWNIb01Wd8SCoIWkaIt9PELQomTZ+OiCgpTORaeiLminQy?= =?Windows-1252?Q?YrZyNeeF0R1/1EpXnauBTvQzCqJwXr0UgCsjTEvHy9laIexQSORAurEF?= =?Windows-1252?Q?22mFuGeBsX01oxtdfI/4kVmvTY7+NEg39x64oD7Jbhf0EDwD3HfKy4LO?= =?Windows-1252?Q?RWrJUR14lqPR6S8RNcWI1YpQVeghcJBZrag28Jn2//CRezUBG9zo2J53?= =?Windows-1252?Q?18dBkPw+SUN3UMpkuKCKVSJl7/7Gt3KTyHY79zRkSpvhmgIbwEHKMRgV?= =?Windows-1252?Q?KQQi7L0663kxkgpiI8eUcRhN6in9RRxTUmSvyjNzR1qunXT4alkYlTed?= =?Windows-1252?Q?ZloMiuZ5MShlbBelj6I7KI3l6zOA8TIqmyaE6IK/QSjwXy9Oq+1u8Lq5?= =?Windows-1252?Q?/a5L9mjTXePjm6SauYgLSH+auVt2ynJL3CtKXtc3FX2c4o1IFunCOC4Y?= =?Windows-1252?Q?68FYq5SuGlNw/SBD5ua7H9/YdQnTCp0U8+IvqGp2n5wjsir+gEa3uk1X?= =?Windows-1252?Q?eBhFRarA8WC6j/ax9TIb9NsQUu+e5LO1YTb8R3E6MCzi5kZitfqRQihZ?= =?Windows-1252?Q?rAvm8NNXCHkwV2uuh6gayXmlWhWl9U5R1QDcYBlkczBpe2NUaixz6BYX?= =?Windows-1252?Q?+GK4kV3la5ZE/Grt4nFhgmnNFkxNF1khlc2hMXHrafoJosjNR4TfeKNA?= =?Windows-1252?Q?JPTiPlTwXcdFr2xAahB?= X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1644;6:7fi8Q1+Vf72QDTKfwF3BufM/5zqU10oZt9UimupVO8zJr/oIsO6ZUYg460lal4JgQaG78iBMQnnTzCe5Gmk2eCG9EL1wS1BzuDaeLa3NdLrUdmYSn+QjHRsgVPrLXe1aWidy30OEoPEpkJ4vwpjkNBjgGbUkCNz4ackXoKIv7kk7xXObiXyW/4qA3DYeQOqX+b06jxsav2z+MjtJeolih8lCUavKOwbSN1nLbQxofmMvLUJ3PwlYgzTb4TaPAt7+TRXJgAw9FWPFUMyE4JodI3qLr54OCwtrHGjivOdFGUCbP2w71qshIChPFSFCm7vl;5:UmETfKHFVJGZHrSlhL0wzf6qSP0bxP5mhe+uEuIxQgRqAIM+KfDNbAFuCObuoBxvLKzbej4RpcoANXAoD0MHwOmpny+x26TwKdsJSEwTbPmcZ7swkgVmPSJYdzZ5YPLwWXzEQleFlcE5Kexg8QX4fg==;24:M40aKQodDBMVND21ubKUyB0XUrRC1n04StuxjE6Sz8948CfLRgNxVFM+BwpyWjm1qPMy46P1J2BemQBJrZp8lQTqXZSPrQdPHm825eqiWOc=;7:6OxXxb416erSa33rY7fwS55GGG9nf1rFaWL9Opk6KzOMzbRyKVp31EfczzcClteamtaOS2IHGPPl+W7jm6mPlIW7pqzctmb2kGrxwPDnVAQ5h4vLmdU6JiSUqCFZ/jzTHP2b4+F3RnOSyCsEzuhUalSmQ7uhqn1TLBeF6atnhTqWKnCOX8+5zwSt0vYUtbQLNgR86E+Nqr4Zlz0CcQa9FYcdugn7fFUIks2++Td0Mv92oQPcjuyjXOrEey9xOYzT SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 06 Sep 2016 16:21:53.0466 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR11MB1644 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 9/5/16 12:14 PM, Bruce Momjian wrote: >> > I have certainly faced my fair share of customers with dangling temp >> > tables, and would like to see this changed in some way or another. > I don't think we look at those temp tables frequently enough to justify > keeping them around for all users. Plus, if we cared about forensics, we'd prevent re-use of the orphaned schemas by new backends. That doesn't seem like a good idea for normal use, but if we had a preserve_orphaned_temp_objects GUC someone could add that behavior. Isn't there some other GUC aimed at preserving data for forensics (besides zero_damaged_pages)? Maybe we could just broaden that to include orphaned temp objects. -- 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