Re: UPDATE

c k wrote:
> I am using PG on windows for development. While testing some queries I
> found that updates are much slower as compared to other database
> systems. (On avarage MySQL updates 4-5 times faster than PG in a single
> unique index on primary key) Why?

Is your MySQL instance using MyISAM tables, or InnoDB?

> Another thing that I noticed is when any single column in a table is
> updated and having no index many (in my case 7) indexes on different
> columns, It takes about 180-200 secs. But when any single column in a
> table is updated and having many (in my case 7) indexes on different
> columns, but does not have index on the column that is being updated, It
> takes about 800-900 secs. Why?

Perhaps you can show us some table definitions and queries with EXPLAIN
ANALYZE output? Your explanation is quite difficult to understand.

> What can be done for such updates to make them faster?

Faster disks :-P

--
Craig Ringer