Re: Speed issues with update

Lorenz,

Have you run VACUUM on the table?

Norman

On Wednesday 01 November 2000 05:43 am, you wrote:
> I'm using 'PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.0, compiled by
> cc'.
>
> The problem is that the following statement takes approx 3hrs on a table
> with approx 136,000 records.
>
> update table_name set state = 10 where pid is null;
>
> pid is indexed. The result from an explain on the statement is as
> follows...
>
> Seq Scan on table_name  (cost=0.00..8668.56 rows=45348 width=310)
>
> When the query is running, disk io is minimal, but cpu is maxed.
>
> Can anyone suggest a solution or a way of finding where pg is spending all
> the cpu time?
>
> Thanks
>
> Loz