Re: [PERFORM] Speeding up JSON + TSQUERY + GIN

On Sun, Feb 26, 2017 at 4:28 PM, Sven R. Kunze wrote: > Hello everyone, > > I am currently evaluating the possibility of using PostgreSQL for storing > and querying jsonb+tsvector queries. Let's consider this setup: > > create table docs (id serial primary key, meta jsonb); > #

[PERFORM] Speeding up JSON + TSQUERY + GIN

Hello everyone, I am currently evaluating the possibility of using PostgreSQL for storing and querying jsonb+tsvector queries. Let's consider this setup: create table docs (id serial primary key, meta jsonb); # generate 10M entries, cf. appendix create index docs_meta_idx ON docs using gin