On Fri, Mar 7, 2014 at 6:46 PM, Mohan Krishnan <mohangk@xxxxxxxxx> wrote:
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)
Your indexes are on columns that are not in the list of columns you gave. Can you show us the actual table and index definitions?
-> 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)
Those estimates are way off, and it is not clear why they would be. Have you analyzed your table recently?
Cheers,
Jeff
