"Bendik R. Johansen" <bendik.johansen@gmail.com> writes:
> Below is the schema for the table i will be using. I tried dropping the
> index, but it did not help.
> Indexes:
> "records_pkey" PRIMARY KEY, btree (id)
> "records_category_idx" gist (category)
> "records_cid_idx" btree (cid)
> "records_uid_idx" btree (uid)
Hmm ... my suspicion would fall first on the GIST index, to tell you the
truth. Did you try dropping that one?
regards, tom lane