Re: Slow update

Yes, I tried dropping it but it did not make a difference.
Could the table be corrupt or something?
Well, the important thing is that I now know that this is not typical
for PostgreSQL, so I will not have to rethink my whole project.

Thanks, so far.


On Apr 12, 2005, at 17:16, Tom Lane wrote:

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