CREATE TABLE spr_article
(
  id bigint NOT NULL,
  clear_text text,
  tsv tsvector,
  CONSTRAINT pk_spr_article_ PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);

CREATE INDEX ftidx_spr_article_0_clear_text_rus ON spr_article USING gin(to_tsvector('russian',clear_text));
CREATE INDEX ftidx_spr_article_0_clear_text_rus_gist ON spr_article USING gist(to_tsvector('russian',clear_text));

SELECT id FROM part.spr_article_0 WHERE clear_text @@ to_tsquery('путин|президент')

SELECT id FROM part.spr_article_0 WHERE clear_text ilike '%путин%'

ALTER TABLE spr_article ADD COLUMN tsv tsvector;
UPDATE spr_article SET tsv = to_tsvector('russian', clear_text);
CREATE TRIGGER tg_tsvector_update_spr_article_0 BEFORE INSERT OR UPDATE ON spr_article FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(tsv, 'russian', title, body);

SELECT id FROM part.spr_article_0 WHERE tsv @@ to_tsquery('президент & путин')

CREATE DATABASE test
  WITH OWNER = postgres
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'ru_RU.UTF-8'
       LC_CTYPE = 'ru_RU.UTF-8'
       CONNECTION LIMIT = -1;

SELECT id FROM part.spr_article_0 WHERE to_tsvector('russian',clear_text) @@ to_tsquery('russian','путин|президент')