index corruption and having to reindex

Started by borajettaover 21 years ago1 messagesbugs
Jump to latest
#1borajetta
borajetta@hotmail.com

select count(*) FROM items_2004_07_29 as items WHERE true AND index @@ to_tsquery('default', '( audiovox)') ;
count
-------
4
(1 row)

aers=# reindex index idx_title_2004_07_29;
REINDEX
aers=# select count(*) FROM items_2004_07_29 as items WHERE true AND index @@ to_tsquery('default', '( audiovox)') ;
count
-------
2342
(1 row)

Here are 2 searches using a gist index, the first one has a gist index which is not properly created but does not though an error in creation. After doing a few searches I noticed the numbers were way off so I reindexed. The problem was fixed and the search works properly.

Is there a problem with indexing? Do you know of this problem?
Is there a way to fix it?

Thank you,

Aaron