Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dXVdP-0004lE-MI for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jul 2017 16:46:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dXVdP-0005C0-97 for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jul 2017 16:46:07 +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 1dXVdO-0005Bo-Qt for pgsql-committers@postgresql.org; Tue, 18 Jul 2017 16:46:06 +0000 Received: from mahout.postgresql.org ([2001:4800:1501:1::227]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dXVdL-0006Hr-Rs for pgsql-committers@postgresql.org; Tue, 18 Jul 2017 16:46:05 +0000 Received: from gemulon.postgresql.org ([2001:4800:1501:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dXVdK-0003DJ-SL for pgsql-committers@postgresql.org; Tue, 18 Jul 2017 16:46:02 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.84_2) (envelope-from ) id 1dXVdK-0005Rc-Cw for pgsql-committers@postgresql.org; Tue, 18 Jul 2017 16:46:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@postgresql.org From: Tom Lane Subject: pgsql: Fix serious performance problems in json(b) to_tsvector(). Message-Id: Date: Tue, 18 Jul 2017 16:46:02 +0000 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-committers Precedence: bulk Sender: pgsql-committers-owner@postgresql.org Rml4IHNlcmlvdXMgcGVyZm9ybWFuY2UgcHJvYmxlbXMgaW4ganNvbihiKSB0 b190c3ZlY3RvcigpLgoKSW4gYW4gb2ZmLWxpc3QgZm9sbG93dXAgdG8gYnVn ICMxNDc0NSwgQm9iIEpvbmVzIGNvbXBsYWluZWQgdGhhdAp0b190c3ZlY3Rv cigpIG9uIGEgMk1CIGpzb25iIHZhbHVlIHRvb2sgYW4gdW5yZWFzb25hYmxl IGFtb3VudCBvZgp0aW1lIGFuZCBzcGFjZSAtLS0gZW5vdWdoIHRvIGRyYXcg dGhlIHdyYXRoIG9mIHRoZSBPT00ga2lsbGVyIG9uCmhpcyBtYWNoaW5lLiAg T24gbXkgbWFjaGluZSwgaGlzIGV4YW1wbGUgcHJvdmVkIHRvIHJlcXVpcmUg dXB3YXJkcwpvZiAxOCBzZWNvbmRzIGFuZCA0R0IsIHdoaWNoIHNlZW1lZCBw cmV0dHkgYm9ndXMgY29uc2lkZXJpbmcgdGhhdAp0b190c3ZlY3RvcigpIG9u IHRoZSBzYW1lIGRhdGEgdHJlYXRlZCBhcyB0ZXh0IHRvb2sganVzdCBhIGNv dXBsZQpodW5kcmVkIG1zZWMgYW5kIDEwIG9yIHNvIE1CLgoKT24gaW52ZXN0 aWdhdGlvbiwgdGhlIHByb2JsZW0gaXMgdGhhdCB0aGUgaW1wbGVtZW50YXRp b24gc2NhbnMgZWFjaApzdHJpbmcgZWxlbWVudCBvZiB0aGUganNvbihiKSBh bmQgY29udmVydHMgaXQgdG8gdHN2ZWN0b3Igc2VwYXJhdGVseSwKdGhlbiBh cHBsaWVzIHRzdmVjdG9yX2NvbmNhdCgpIHRvIGpvaW4gdGhvc2Ugc2VwYXJh dGUgdHN2ZWN0b3JzLgpUaGUgdW5yZWFzb25hYmxlIG1lbW9yeSB1c2FnZSBj YW1lIGZyb20gbGVha2luZyBldmVyeSBzaW5nbGUgb25lIG9mCnRoZSB0cmFu c2llbnQgdHN2ZWN0b3JzIC0tLSBidXQgZXZlbiB3aXRob3V0IHRoYXQgbWlz dGFrZSwgdGhpcyBpcyBhbgpPKE5eMikgb3Igd29yc2UgYWxnb3JpdGhtLCBi ZWNhdXNlIHRzdmVjdG9yX2NvbmNhdCgpIGhhcyB0byByZXBlYXRlZGx5CnBy b2Nlc3MgdGhlIHdvcmRzIGNvbWluZyBmcm9tIGVhcmxpZXIgZWxlbWVudHMu CgpXZSBjYW4gZml4IGl0IGJ5IGFjY3VtdWxhdGluZyBhbGwgdGhlIGxleGVt ZSBkYXRhIGFuZCBhcHBseWluZwptYWtlX3RzdmVjdG9yKCkganVzdCBvbmNl LiAgQXMgYSBzaWRlIGJlbmVmaXQsIHRoYXQgYWxzbyBtYWtlcyB0aGUKZGVz aXJlZCBhZGp1c3RtZW50IG9mIGxleGVtZSBwb3NpdGlvbnMgZmFyIGNoZWFw ZXIsIGJlY2F1c2Ugd2UgY2FuCmp1c3QgdHdlYWsgdGhlIHJ1bm5pbmcgInBv cyIgY291bnRlciBiZXR3ZWVuIEpTT04gZWxlbWVudHMuCgpJbiBwYXNzaW5n LCB0cnkgdG8gbWFrZSB0aGUgZXhwbGFuYXRpb24gb2YgdGhhdCB0d2VhayBt b3JlIGludGVsbGlnaWJsZS4KKEkgZGlkbid0IHRoaW5rIHRoYXQgYSBiYXJl bHktcmVhZGFibGUgY29tbWVudCBmYXIgcmVtb3ZlZCBmcm9tIHRoZQphY3R1 YWwgY29kZSB3YXMgaGVscGZ1bC4pICBBbmQgZG8gc29tZSBtaW5vciBvdGhl ciBjb2RlIGJlYXV0aWZpY2F0aW9uLgoKQnJhbmNoCi0tLS0tLQptYXN0ZXIK CkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmL2I0YzZkMzFjMGJlMGY1YzQyYTc1ZDUwYWZjZjEzYmRk MzkyZGI0YTEKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9i YWNrZW5kL3RzZWFyY2gvdG9fdHNhbnkuYyB8IDEyMCArKysrKysrKysrKysr KysrKysrKy0tLS0tLS0tLS0tLS0tLS0tLS0tLQpzcmMvaW5jbHVkZS90c2Vh cmNoL3RzX3R5cGUuaCAgfCAgIDkgLS0tLQoyIGZpbGVzIGNoYW5nZWQsIDU4 IGluc2VydGlvbnMoKyksIDcxIGRlbGV0aW9ucygtKQoKCi0tIApTZW50IHZp YSBwZ3NxbC1jb21taXR0ZXJzIG1haWxpbmcgbGlzdCAocGdzcWwtY29tbWl0 dGVyc0Bwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIg c3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxw cmVmL3Bnc3FsLWNvbW1pdHRlcnMK