Re: Slow update - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow update
Date
Msg-id 16172.1113319006@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow update  (Bendik R.Johansen <bendik.johansen@gmail.com>)
Responses Re: Slow update
List pgsql-performance
"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

pgsql-performance by date:

Previous
From: Bendik R.Johansen
Date:
Subject: Re: Slow update
Next
From: Bendik R.Johansen
Date:
Subject: Re: Slow update