I am trying to do an update on column in a table with 1.5 millions rows.
The SQL is as follows, I am also putting it in a transaction in case things
go wrong.
begin;
update statistics set parameters = NULL where parameters ='';
An explain produces the following: -
Seq Scan on statistics (cost=0.00..56174.49 rows=14976 width=88)
Would anyone be able to tell me why it is seemingly infinite, i'm running
linux, postgres v7.0
Cheers
Graham