[BUGS] Strange problem with an index.

2007-11-16 Thread Blanco, Jose
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 a

Re: [BUGS] Strange problem with an index.

2007-11-15 Thread Tom Lane
"Blanco, Jose" <[EMAIL PROTECTED]> writes: > Well, this was running very slowly, so I droped the index and recreated > it, and then it ran quickly. Sounds like you had a bloated index. > I'm running versin 7.3 Consider switching to something more modern --- 7.3 is vastly slower than current rele