Benjamin Krajmalnik wrote: > I recently truncated a partitioned table. > > When I look at the statistics for the table, it shows tuples inserted as > zero (which I would expect), but it did not clear the value for tuples > updated and tuples deleted. > > Is this the expected behavior? I would assume that the updated/deleted > stats should also get cleared. > > > > I am running PG 8.1.4 on Windows. Stats get updated by the ANALYZE command. Run it on the table and check again. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
