| From: | "Blanco, Jose" <blancoj(at)umich(dot)edu> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Strange problem with an index. |
| Date: | 2007-11-15 19:09:10 |
| Message-ID: | E0217C87D1BA1043AC897ACFA468CEE6015131F7@ECLUST2-VS3.adsroot.itcs.umich.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
I have the following table
Table "public.authorsort"
Column | Type | Modifiers
----------+-----------------------+-----------
ordernum | integer |
handle | character varying(30) |
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 = '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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-11-15 21:12:20 | Re: Strange problem with an index. |
| Previous Message | Magnus Hagander | 2007-11-15 18:40:47 | Re: BUG #3750: Invalid frontend message type 112 |