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
"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