Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rt49O-00BqBk-8k for pgsql-docs@arkaria.postgresql.org; Sat, 06 Apr 2024 11:23:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rt49L-00BOyw-R7 for pgsql-docs@arkaria.postgresql.org; Sat, 06 Apr 2024 11:23:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rsq9U-005AWW-VM for pgsql-docs@lists.postgresql.org; Fri, 05 Apr 2024 20:27:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rsq9R-000nvx-RS for pgsql-docs@lists.postgresql.org; Fri, 05 Apr 2024 20:27:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=XgTozHPcEDeXZXazOm1Ld2P1wEEbfW/itjSZFit2fDM=; b=QZQ9pwXh2A7WR575xISBA263Mw 9n4xNkYAfBbagmJLhvt2g82dFAykpVCjitUKHlWJplQXdwkHK4u2ijT4id8raVVcwEWHMcV+sOr/3 oUkQbFRafkVn3ew/SwO9PRehN5+iSuT6AEPbJ87srj/Lj1+OjWOFikVyc/dkaxV8ToMbpvdN8uVzA dc55/vOMxkMOX/KwlvkkcIo4pHx7ixELmN3YtxQIlW4S8NCn7iaU4KCQy8tOFPiYCv8AZec3vMdwz EHqsrcoVZrMxDSgaAovEt1TUhapixHJaDx74Jo5MYdU1bwQUEgAHvZNoM0Hw3SIizBwLwrtbHey19 MNXGQxVQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rsq9Q-0025fq-OK for pgsql-docs@lists.postgresql.org; Fri, 05 Apr 2024 20:27:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rsq9O-007K3U-I0 for pgsql-docs@lists.postgresql.org; Fri, 05 Apr 2024 20:27:03 +0000 Content-Type: multipart/mixed; boundary="===============8847105035063482922==" MIME-Version: 1.0 Subject: RE: ts_headline performance note To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: cgodwin@fearless.tech Reply-To: cgodwin@fearless.tech, pgsql-docs@lists.postgresql.org Date: Fri, 05 Apr 2024 20:26:09 +0000 Message-ID: <171234876917.679.13797728491969928179@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8847105035063482922== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNi90ZXh0 c2VhcmNoLWNvbnRyb2xzLmh0bWwKRGVzY3JpcHRpb246CgpUaGlzIGlzIGEgZm9sbG93dXAgdG8K aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC8xNzExNzU0NzYyMTQuNzEwNC42 MjMzODk5ODUxNjAwNzQ5Nzg5JTQwd3JpZ2xleXMucG9zdGdyZXNxbC5vcmcNCg0KSSBhbSBhIGRl dmVsb3BlciBvbiB0aGUgdGVhbSB0aGF0IGZpeGVkIHRoZSBwZXJmb3JtYW5jZSBpc3N1ZXMgd2l0 aCBvdXIKdXNhZ2Ugb2YgdHNfaGVhZGxpbmUuIEkgd2FudCB0byBnaXZlIGEgbGl0dGxlIGJpdCBv ZiBjb250ZXh0IG9uIGhvdyB3ZQpub3RpY2VkIHRoZSBpc3N1ZSBhbmQgZml4ZWQgaXQuDQoNCldl IGZpcnN0IG5vdGljZWQgdGhlIGlzc3VlIHdoZW4gd2UgYmVnYW4gaW5kZXhpbmcgbGFyZ2UgbnVt YmVycyBvZgptdWx0aS1tZWdhYnl0ZSB0ZXh0IGNvbnRlbnQgaW4gb3VyIGRhdGFiYXNlLiBJdCB3 YXMgY2F1c2luZyBvdXIgc2VhcmNoCmVuZHBvaW50IHRvIHNsb3cgZG93biBzaWduaWZpY2FudGx5 IGFuZCwgaW4gbWFueSBjYXNlcywgdGltZSBvdXQgd2l0aCBxdWVyeQp0aW1lcyBncmVhdGVyIHRo YW4gMTAgc2Vjb25kcy4gV2UgYXNzdW1lZCBpdCB3YXMgYSBwZXJmb3JtYW5jZSBpc3N1ZSB3aXRo CnNlYXJjaCAobWF5YmUgd2l0aCBvdXIgaW5kZXhpbmcgb3IgdmVjdG9yIGltcGxlbWVudGF0aW9u KSwgYnV0IGluIGEgcHJvY2VzcwpvZiBlbGltaW5hdGlvbiB3ZSBoYXBwZW5lZCB0byByZW1vdmUg b3VyIHRzX2hlYWRsaW5lIGFubm90YXRpb25zIGFuZCB0aGF0CmZpeGVkIHRoZSBpc3N1ZS4NCg0K V2UgcmVhbGl6ZWQgdGhhdCBhZGRpbmcgdHNfaGVhZGxpbmUgYmFjayBhbmQgc2xvd2x5IGluY3Jl YXNpbmcgb3VyIHJlc3VsdApzZXQgc2hvd2VkIHRoYXQgZm9yIHNvbWUgcmVzdWx0cyBpbiB0aGUg c2V0LCB0c19oZWFkbGluZSBjYW1lIGJhY2sgcXVpY2tseQoobGVzcyB0aGFuIDEwbXMpIGFuZCBp biBvdGhlciBjYXNlcyBpdCBhZGRlZCBodW5kcmVkcyAob2NjYXNpb25hbGx5CnRob3VzYW5kcykg b2YgbWlsbGlzZWNvbmRzIGZvciBhIHNpbmdsZSByZXN1bHQuIEZyb20gdGhlcmUgd2UgY29tcHV0 ZWQgdGhhdAppbiBvdXIgcGFydGljdWxhciB1c2UgY2FzZSwgdHNfaGVhZGxpbmUgc2VlbXMgdG8g aGF2ZSBhIG1heGltdW0gcHJvY2Vzc2luZwpzcGVlZCBvZiBiZXR3ZWVuIDMtNSBNQi9zLCBhbmQg cHJvY2Vzc2luZyBlbnRpcmUgcGFnZXMgb2YgcmVzdWx0cyB3aXRoIHNvbWUKcmVzdWx0cyBjb250 YWluaW5nIG11bHRpcGxlIG1lZ2FieXRlcyBvZiB0ZXh0IHdhcyBub3QgZmVhc2libGUuDQoNCldl IHNvbHZlZCB0aGlzIGlzc3VlIGluIHRocmVlIHdheXM6DQoNCkZpcnN0LCB3ZSBhcmUgZW5zdXJp bmcgdGhhdCBvdXIgZnJvbnRlbmQgaXMgZnVsbHkgdXRpbGl6aW5nIHBhZ2luYXRpb24gdG8KcmVk dWNlIHRoZSBudW1iZXIgb2YgcmVzdWx0cyB0c19oZWFkbGluZSBtdXN0IHByb2Nlc3MgcGVyIHJl cXVlc3QuDQoNClNlY29uZCwgd2UgYXJlIGZvcmNpbmcgb3VyIERqYW5nbyBhcHBsaWNhdGlvbiB0 byBwYWdpbmF0ZSB0aGUgZGF0YSBiZWZvcmUKZ2VuZXJhdGluZyBoZWFkbGluZXMsIHRoZXJlYnkg ZW5zdXJpbmcgdGhhdCB0c19oZWFkbGluZSBpcyBub3QgcnVubmluZyBmb3IKdGhlIGVudGlyZSBy ZXN1bHQgc2V0IG9mIHRoZSBzZWFyY2ggb3BlcmF0aW9uLCBidXQgb25seSBhIHN1YnNldC4gVGhp cyB3YXMKbm90IGltbWVkaWF0ZWx5IG9idmlvdXMgYXMgRGphbmdvJ3MgT1JNIHNlZW1zIHRvIGF0 dGVtcHQgdG8gb3B0aW1pemUgdG8gdGhlCnNtYWxsZXN0IG51bWJlciBvZiBxdWVyaWVzIGZvciBh IGdpdmVuIG9wZXJhdGlvbiBieSBkZWZhdWx0LCBpbnN0ZWFkIG9mCm9wdGltaXppbmcgdG93YXJk IGxlYXN0IHRpbWUuIFdlIGFjY29tcGxpc2hlZCB0aGlzIGJ5IHNlYXJjaGluZywgdGhlbgpwYWdp bmF0aW5nLCB0aGVuIGV4dHJhY3RpbmcgdGhlIHByaW1hcnkga2V5cyBvZiB0aGUgcGFnaW5hdGlv biByZXN1bHQgaW50byBhCmxpc3Qgd2hpY2ggd2UgZmVlZCBpbnRvIGFub3RoZXIgcXVlcnkgZm9y IHRzX2hlYWRsaW5lIHRvIHdvcmsgb24uDQoNCkZpbmFsbHksIHdlIGFyZSBhbm5vdGF0aW5nIGEg c3Vic3RyaW5nIChjdXJyZW50bHkgdGhlIGZpcnN0IDUwLDAwMApjaGFyYWN0ZXJzKSBvZiB0aGUg ZmllbGQgdGhhdCBvZnRlbiBjb250YWlucyBsYXJnZSBhbW91bnRzIG9mIHRleHQgYW5kCnJ1bm5p bmcgdHNfaGVhZGxpbmUgb24gdGhhdCBpbnN0ZWFkLiBXZSBmb3VuZCB0aGF0IGlmIHdlIHN0aWNr IHRvIGEgbWF4aW11bQpwZXIgcmVzdWx0IHRleHQgZmllbGQgc2l6ZSBvZiA1MGssIHRzX2hlYWRs aW5lIGNvbnNpc3RlbnRseSB0YWtlcyAxMG1zIG9yCmxlc3MgcGVyIHJlc3VsdCBpbiBvdXIgdXNl IGNhc2UsIGFuZCB3ZSBmaW5kIHRoYXQgYWNjZXB0YWJsZSBmb3IgdGhlIHBhZ2UKc2l6ZXMgdGhh dCB3ZSBhcmUgcmV0dXJuaW5nLg0KDQpUaGUgdHJhZGVvZmYgd2l0aCB0aGlzIHNvbHV0aW9uIGlz IHRoYXQgdHNfaGVhZGxpbmUgd2lsbCBub3QgYWx3YXlzIGZpbmQKdGV4dCB0byBoaWdobGlnaHQg aW4gdGhlIHN1YnN0cmluZywgYnV0IHdlIGZpbmQgdGhhdCBhY2NlcHRhYmxlIGFzIHdlbGwgZHVl CnRvIG91ciBuZWVkIGZvciBiZXR0ZXIgcGVyZm9ybWFuY2UuDQoNCkl0IG1heSBiZSBoZWxwZnVs IHRvIGluY2x1ZGUgc29tZXRoaW5nIGxpa2UgdGhpcyBpbiB0aGUgZG9jcyBmb3IKdHNfaGVhZGxp bmU6DQoNCj4gdHNfaGVhZGxpbmUgdXNlcyB0aGUgb3JpZ2luYWwgZG9jdW1lbnQsIG5vdCBhIHRz dmVjdG9yIHN1bW1hcnksIHNvIGl0IGNhbgpiZSBzbG93IGFuZCBzaG91bGQgYmUgdXNlZCB3aXRo IGNhcmUuIEZvciBleGFtcGxlOg0KPiAqIENvbnNpZGVyIHVzaW5nIHBhZ2luYXRpb24gd2hlbiBz ZWFyY2hpbmcgdGhyb3VnaCBsYXJnZSBkYXRhIHNldHMuDQo+ICogSWYgeW91J3JlIHVzaW5nIHBh Z2luYXRpb24sIGVuc3VyZSB5b3VyIGFwcGxpY2F0aW9uIGlzIHBhZ2luYXRpbmcgdGhlCmRhdGEg YmVmb3JlIGdlbmVyYXRpbmcgaGVhZGxpbmVzLCBzbyB0aGF0IHRzX2hlYWRsaW5lIGlzIG5vdCBy dW5uaW5nIGZvciB0aGUKZW50aXJlIHJlc3VsdCBzZXQgb2YgdGhlIHNlYXJjaCBvcGVyYXRpb24s IGJ1dCBvbmx5IGEgc3Vic2V0Lg0KPiAqIENvbnNpZGVyIGxpbWl0aW5nIHRzX2hlYWRsaW5lIHRv IHJ1bm5pbmcgb24gYSBsaW1pdGVkIGFtb3VudCBvZiB0ZXh0CmZyb20gZWFjaCBkb2N1bWVudCwg aW5zdGVhZCBvZiB0aGUgZW50aXJlIGRvY3VtZW50Lg0KPiAqIENvbnNpZGVyIHNldHRpbmcgdXAg YSB0aW1lb3V0IGZvciB0aGUgdHNfaGVhZGxpbmUgb3BlcmF0aW9uLCBzbyB0aGF0IGlmCml0IHRh a2VzIHRvbyBsb25nLCBzZWFyY2ggcmVzdWx0cyBhcmUgZGVsaXZlcmVkIHdpdGhvdXQgaGVhZGxp bmVzLgo= --===============8847105035063482922==--