"Bendik R. Johansen" <bendik(dot)johansen(at)gmail(dot)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