Re: [HACKERS] strange behavior of UPDATE

> - update bench set k500k = k500k + 1 where k100 = 30
> with indeces unknown
> without indeces 36 seconds

can you run an: explain update bench set k500k = k500k + 1 where k100 = 30;

> Still the poor update routines do not explain the
> strange behavior, that the postmaster runs for
> hours using at most 10% CPU, and all the time
> heavy disk activity is observed.

I suspect it is doing a seq scan. Thus explaining the heavy disk activity.
I have previously sent in a patch which will fix this if someone applies it.

Andreas