Re: Slow update

"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