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
Yup, a full VACUUM analyze was done on the table. The problem seems to be
that 95% of processor time is spent in the kernal opening and closing the
same table file. This does seem a little strange. Could this be a problem
with the code? I've also tried a full reinstall, but to no avail.
Loz
On T
