Hello,
I am having a bit of trouble updating a single integer column.
My table has around 10 columns and 260 000 records.
update no.records set uid = 2;
(uid is an integer. It has a btree index)
This update takes more than 20 minutes to execute. Is this normal? This
will be totally unacceptable wh
Hello, thank you for the quick reply.
I am running version 8.0.1
Below is the schema for the table i will be using. I tried dropping the
index, but it did not help.
Table "no.records"
Column| Type |
Modifie
:
"Bendik R. Johansen" <[EMAIL PROTECTED]> 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 (categor