ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at> writes:
> can you run an: explain update bench set k500k = k500k + 1 where k100 = 30;
> I suspect it is doing a seq scan.
No, that's not it:
test=> explain update bench set k500k = k500k + 1 where k100 = 30;
NOTICE: QUERY PLAN:
Index Scan using k100 on bench (cost=179.05 rows=2082 width=154)
The benchmark loads the tables first and then builds indexes, and
in fact does a vacuum analyze after that! So the stats should be fine.
regards, tom lane
