Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e0FHF-00018k-5d for pgsql-bugs@arkaria.postgresql.org; Thu, 05 Oct 2017 23:10:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e0FHE-0008Lh-Mp for pgsql-bugs@arkaria.postgresql.org; Thu, 05 Oct 2017 23:10:00 +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 1e0FBW-0004wN-O0 for pgsql-bugs@postgresql.org; Thu, 05 Oct 2017 23:04:06 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e0FBS-0004f0-RD for pgsql-bugs@postgresql.org; Thu, 05 Oct 2017 23:04:05 +0000 MIME-Version: 1.0 Subject: BUG #14843: CREATE TABLE churns through all memory, crashes db To: pgsql-bugs@postgresql.org From: ropeladder@gmail.com Cc: ropeladder@gmail.com Date: Thu, 05 Oct 2017 23:03:21 +0000 Message-ID: <20171005230321.28561.15927@wrigleys.postgresql.org> Content-Transfer-Encoding: base64 Content-Type: text/plain; charset="utf-8" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDg0MwpMb2dnZWQgYnk6ICAg ICAgICAgICBCZW4KRW1haWwgYWRkcmVzczogICAgICByb3BlbGFkZGVyQGdt YWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEwcmMxCk9wZXJhdGluZyBz eXN0ZW06ICAgTGludXggTWludCAxOC4yCkRlc2NyaXB0aW9uOiAgICAgICAg CgooZmlyc3QgYnVnIHJlcG9ydCBoZXJlIHNvIHBsZWFzZSBsZXQgbWUga25v dyBpZiB0aGlzIGNhbiBiZSBpbXByb3ZlZCkNCg0KQ29uZ3JhdHMgb24gdGhl IG5ldyByZWxlYXNlIQ0KDQpJIGp1c3QgaW5zdGFsbGVkIHYxMCBhbmQgYW0g dHJ5aW5nIHRvIHJlLXJ1biBhbiBFVEwgSSBoYWQgc2NyaXB0ZWQuIEknbQp1 bmFibGUgdG8gcnVuIGEgQ1JFQVRFIFRBQkxFIGNvbW1hbmQgdGhhdCB3b3Jr cyBmaW5lIGluIDkuNiAoaXQgdG9vayA4MwpzZWNvbmRzKS4gV2hlbiBJIHRy eSB0byBydW4gaXQgaW4gdjEwIGl0IHF1aWNrbHkgbWF4ZXMgb3V0IG15IFJB TSB1c2FnZSBhbmQKdGhlbiBzd2FsbG93cyB1cCBhbGwgbXkgdmlydHVhbCBt ZW1vcnkgYmVmb3JlIGZpbmFsbHkgIGNyYXNoaW5nClBvc3RncmVTUUwuDQoN ClRoZSBjb21tYW5kIHRha2VzIGEgdGFibGUgd2l0aCBvbmUganNvbmIgZG9j dW1lbnQgYW5kIGNyZWF0ZXMgYSBuZXcgdGFibGUKd2l0aCAzIHJvd3M6IG9u ZSBqc29uYiwgb25lIHRleHQsIGFuZCBvbmUgdGltZXN0YW1wLiBUaGUgaW5p dGlhbCB0YWJsZSBoYXMKMi42TSByb3dzLCB0aGUgbmV3IHRhYmxlIHNob3Vs ZCBoYXZlIDQuOU0gcm93cyAoYmVjYXVzZSBvZiBhCmpzb25iX2FycmF5X2Vs ZW1lbnRzKCkgZXhwYW5zaW9uKS4gVGhlIGFjdHVhbCBxdWVyeSBpcyBiZWxv dzoNCg0KQ1JFQVRFIFRBQkxFIG5ld190YWJsZSBhcyAoDQpTRUxFQ1QNCiAg ICBqc29uYl9hcnJheV9lbGVtZW50cyhkb2MtPid0ZXh0Jy0+MC0+J2hhc2F1 dGhvcicpIGRvYywNCiAgICBkb2MtPid0ZXh0Jy0+MC0+JyQnLT4+J2lkJyBy aWQsDQogICAgcmVnZXhwX3JlcGxhY2UoZG9jLT4+J210aW1lJywnW1RaXScs JyAnKTo6dGltZXN0YW1wIG10aW1lDQpGUk9NIHNvdXJjZV90YWJsZQ0KV0hF UkUgKGRvYyM+J3sidGV4dCIsMCwiaGFzYXV0aG9yIn0nKSBJUyBOT1QgTlVM TCkNCg0KVGhlIDIuNk0ganNvbmIgZG9jdW1lbnRzIGluIHRoZSBzb3VyY2Ug dGFibGUgYXJlIHN0cnVjdHVyZWQgc2ltaWxhciB0bwp0aGlzOg0KDQp7IiQi OiB7InhtbG5zIjogImh0dHA6Ly9hbWYub3BlbmxpYi5vcmciLCAieG1sbnM6 eHNpIjoKImh0dHA6Ly93d3cudzMub3JnLzIwMDEvWE1MU2NoZW1hLWluc3Rh bmNlIiwgInhtbG5zOnJlcGVjIjoKImh0dHA6Ly9yZXBlYy5vcGVubGliLm9y ZyIsICJ4c2k6c2NoZW1hTG9jYXRpb24iOiAiaHR0cDovL2FtZi5vcGVubGli Lm9yZwpodHRwOi8vYW1mLm9wZW5saWIub3JnLzIwMDEvYW1mLnhzZCJ9LCAi dGV4dCI6IFt7IiQiOiB7ImlkIjoKIlJlUEVjOnp3aTppcGFwZXI6NTYifSwg ImRhdGUiOiBbeyIkIjogeyJldmVudCI6ICJjcmVhdGVkIn0sICJfIjoKIjIw MDktMDIifV0sICJmaWxlIjogW3sidXJsIjoKWyJodHRwOi8vd3d3LnVybC5l ZHUvZG9jdW1lbnRzL2lzc3VlcGFwZXJzL2lwNTYucGRmIl0sICJmb3JtYXQi OgpbImFwcGxpY2F0aW9uL3BkZiJdfV0sICJ0eXBlIjogWyJwcmVwcmludCJd LCAidGl0bGUiOiBbIlRoZSBOZWVkIGZvciBOZXcKTWlsayBQcmljaW5nIFBv bGljaWVzIl0sICJzdGF0dXMiOiBbIk51bWJlciA1NiAxOCBwYWdlcyJdLCAi YWJzdHJhY3QiOgpbIkxvbmcgdGV4dCBzdHJpbmcuIl0sICJpc3BhcnRvZiI6 IFt7ImNvbGxlY3Rpb24iOiBbeyIkIjogeyJyZWYiOgoiUmVQRWM6endpOmlw YXBlciJ9fV19XSwgImtleXdvcmRzIjogWyJtaWxrLCBkYWlyeSwgcHJpY2lu ZywgcHJpY2UgZ291Z2luZywKTmV3IEVuZ2xhbmQiXSwgImhhc2F1dGhvciI6 IFt7InBlcnNvbiI6IFt7Im5hbWUiOiBbIkFkYW0gTGFzdG5hbWUiXSwKImVt YWlsIjogWyJlbWFpbEBnbWFpbC5jb20iXSwgImlzcGFydG9mIjogW3sib3Jn YW5pemF0aW9uIjogW3sibmFtZSI6ClsiVW5pdmVyc2l0eSBvZiBDb25uZWN0 aWN1dCJdfV19XX1dfSwgeyJwZXJzb24iOiBbeyJuYW1lIjogWyJSb25hbGQK TGFzdG5hbWUiXSwgImVtYWlsIjogWyJlbWFpbEBlbWFpbC5jb20iXSwgImlz cGFydG9mIjogW3sib3JnYW5pemF0aW9uIjoKW3sibmFtZSI6IFsiVW5pdmVy c2l0eSBvZiBDb25uZWN0aWN1dCJdfV19XX1dfV19XSwgIm10aW1lIjoKIjIw MTQtMDUtMzFUMDM6NTk6MzMuMDAwWiJ9CgoKLS0gClNlbnQgdmlhIHBnc3Fs LWJ1Z3MgbWFpbGluZyBsaXN0IChwZ3NxbC1idWdzQHBvc3RncmVzcWwub3Jn KQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6 Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtYnVncwo=