Slow update

From: Bendik R(dot)Johansen <bendik(dot)johansen(at)gmail(dot)com>
To: PostgreSQL Perform <pgsql-performance(at)postgresql(dot)org>
Subject: Slow update
Date: 2005-04-12 14:12:32
Message-ID: 0201deb23790cee173bdd2d3f0e96642@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 when my table grows.
Any ideas?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Turner 2005-04-12 14:18:31 Re: profiling postgresql queries?
Previous Message Tom Lane 2005-04-12 14:10:53 Re: profiling postgresql queries?