| 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: | Whole Thread | Raw Message | 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 |