Re: Inconsistent query times and spiky CPU with GIN tsvector search

2018-09-04 Thread Laurenz Albe
Scott Rankin wrote: > We are running postgresql 9.4 and we have a table where we do some > full-text searching using a GIN index on a tsvector column: > > CREATE INDEX location_search_tsvector_idx > ON public.location_search USING gin > (search_field_tsvector) > TABLESPACE pg_default;

Inconsistent query times and spiky CPU with GIN tsvector search

2018-09-04 Thread Scott Rankin
Hello all, We are running postgresql 9.4 and we have a table where we do some full-text searching using a GIN index on a tsvector column: CREATE TABLE public.location_search ( id bigint NOT NULL DEFAULT nextval('location_search_id_seq'::regclass), … search_field_tsvector tsvector )