From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Postgres 11 release notes |
Date: | 2018-05-11 21:06:52 |
Message-ID: | 20180511210652.GK18510@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-www |
On Fri, May 11, 2018 at 10:20:17PM +0300, Teodor Sigaev wrote:
> >>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.
Done and URL updated.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2018-05-11 21:17:19 | Re: lazy detoasting |
Previous Message | Bruce Momjian | 2018-05-11 21:04:05 | Re: Postgres 11 release notes |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2018-05-12 20:22:55 | Re: Postgres 11 release notes |
Previous Message | Bruce Momjian | 2018-05-11 21:04:05 | Re: Postgres 11 release notes |