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.