Re: Postgres 11 release notes
От | Teodor Sigaev |
---|---|
Тема | Re: Postgres 11 release notes |
Дата | |
Msg-id | aebf5f72-02a2-61e1-008f-525169e48474@sigaev.ru обсуждение исходный текст |
Ответ на | Re: Postgres 11 release notes (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: Postgres 11 release notes
|
Список | pgsql-hackers |
>> 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@sigaev.ru WWW: http://www.sigaev.ru/
В списке pgsql-hackers по дате отправления: