From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Postgres 11 release notes |
Date: | 2018-05-11 19:20:17 |
Message-ID: | aebf5f72-02a2-61e1-008f-525169e48474@sigaev.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | Postg토토 꽁 머니SQL pgsql-www |
>> 857f9c36cda520030381bd8c2af20adf0ce0e1d4 Skip full index scan during cleanup
>> of B-tree indexes when possible
>
> I read that and thought it was too details to be in the release notes.
> It is not that it is unimportant, but it is hard to see how people would
> notice the difference or change their behavior based on this change.
Hm, it could be something like:
Add possibility to miss scan indexes on append-only table, it decreases
vacuum time on such tables.
>
>> c0cbe00fee6d0a5e0ec72c6d68a035e674edc4cc Add explicit cast from scalar jsonb
>> to all numeric and bool types.
>>
>> Pls, edit:
>> Add functionjson(b)_to_tsvector to create usable text search queries
>> matching JSON/JSONB values (Dmitry Dolgov)
>> to
>> Add function json(b)_to_tsvector to create usable vectors to search in
>> json(b) (Dmitry Dolgov)
>> or somehow else. Your wording is about query but actually that functions are
>> about how to create tsvector from json(b)
>
> OK, how is this text?
>
> Add function <function>json(b)_to_tsvector()</function> to create
> text search query for matching <type>JSON</type>/<type>JSONB
> </type>values (Dmitry Dolgov)
Not query - *_to_tsvector functions produce a tsvector. So:
Add function <function>json(b)_to_tsvector()</function> to use
customizable full text search over json(b) columns.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2018-05-11 19:22:08 | Re: Postgres 11 release notes |
Previous Message | Peter Geoghegan | 2018-05-11 19:17:47 | Re: Postgres 11 release notes |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2018-05-11 19:22:08 | Re: Postgres 11 release notes |
Previous Message | Peter Geoghegan | 2018-05-11 19:17:47 | Re: Postgres 11 release notes |