From: | "borajetta" <borajetta(at)hotmail(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | index corruption and having to reindex |
Date: | 2004-08-03 21:55:11 |
Message-ID: | BAY17-DAV15GDXh1nWp000846cd@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Hernandez | 2004-08-04 04:38:37 | could not create shared memory segment - i386 |
Previous Message | PostgreSQL Bugs List | 2004-08-03 00:23:23 | BUG #1203: Dropping a user does not revoke their permissions |