Strange problem with an index.
От | Blanco, Jose |
---|---|
Тема | Strange problem with an index. |
Дата | |
Msg-id | E0217C87D1BA1043AC897ACFA468CEE6015131F7@ECLUST2-VS3.adsroot.itcs.umich.edu обсуждение исходный текст |
Ответ на | BUG #3750: Invalid frontend message type 112 ("Christian Ullrich" <chris@chrullrich.net>) |
Ответы |
Re: Strange problem with an index.
|
Список | pgsql-bugs |
I have the following table=20=20=20=20=20=20=20=20=20=20 Table "public.authorsort" Column | Type | Modifiers=20 ----------+-----------------------+----------- ordernum | integer |=20 handle | character varying(30) |=20 Indexes: author_handle_idx btree (handle) As you can tell I have an index on handle. In my perl script I loop trough series of select statements that look like this: Select ordernum from authorsort where handle =3D 'somvevalue'; Well, this was running very slowly, so I droped the index and recreated it, and then it ran quickly. I'm running versin 7.3 and I noticed that in versin 8, the following has been done: Prevent index corruption when a transaction inserts rows and then aborts close to the end of a concurrent VACUUM on the same table (Tom) And we recently added vacumm --full to our system. Could this be the reason? Thanks! Jose
В списке pgsql-bugs по дате отправления: