Hello folks, I have a table of about 700k rows in Postgres 9.3.3, which has the following structure: Columns: content_body - text publish_date - timestamp without time zone published - boolean Indexes: "articles_pkey" PRIMARY KEY, btree (id) "article_text_gin" gin (article_text) "articles_publish_date_id_index" btree (publish_date DESC NULLS LAST, id DESC)
-> Index Scan using articles_pkey on articles (cost=0.42..462150.49 rows=3573 width=1298) (actual time=2.055..9.711 rows=10 loops=1) Filter: (article_text @@ '''in_index'''::tsquery)
-> Index Scan using articles_pkey on articles (cost=0.42..462150.49 rows=3573 width=1298) (actual time=5633.672..5633.672 rows=0 loops=1) Filter: (article_text @@ '''not_in_index'''::tsquery)
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных