RE: Re: Re: Postgres Full Text Search Jsonb Array column does not search for first row

2019-12-01 Thread Dmytro Zhluktenko
: Re: Postgres Full Text Search Jsonb Array column does not search for first row On Wed, 2019-11-27 at 11:54 +0200, Dmytro Zhluktenko wrote:> explain (analyze, BUFFERS)> SELECT *> FROM "cp"."Repro" x where cp.make_tsvector(x) @@ 'fir:*'::tsquery> >

Re: Re: Postgres Full Text Search Jsonb Array column does not search for first row

2019-11-28 Thread Laurenz Albe
On Wed, 2019-11-27 at 11:54 +0200, Dmytro Zhluktenko wrote: > explain (analyze, BUFFERS) > SELECT * > FROM "cp"."Repro" x where cp.make_tsvector(x) @@ 'fir:*'::tsquery > > outputs this query plan: > Bitmap Heap Scan on "Repro" x (cost=12.00..16.26 rows=1 width=72) (actual > time=0.007..0.007 row

RE: Re: Postgres Full Text Search Jsonb Array column does not search for first row

2019-11-27 Thread Dmytro Zhluktenko
off, then query still does the same result.Also, if you add 10 more entries, it will still fail to find the first one using index. BR, Dmytro. From: Laurenz AlbeSent: 26 листопада 2019 р. 21:13To: Dmytro Zhluktenko; pgsql-general@lists.postgresql.orgSubject: Re: Postgres Full Text Search Json

Re: Postgres Full Text Search Jsonb Array column does not search for first row

2019-11-26 Thread Laurenz Albe
On Tue, 2019-11-26 at 13:37 +0200, Dmytro Zhluktenko wrote: > Pgsql is unable to perform indexed full text search onto jsonb column > containing an array when looking for the first row in the table. > > Any ideas why this is happening? > > CREATE OR REPLACE FUNCTION cp.make_tsvector(in_t cp."Re