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
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
In response to
pgsql-admin by date
|Next:||From: Praveen Kumar N||Date: 2006-06-15 04:56:59|
|Subject: database physical storage|
|Previous:||From: Scott Marlowe||Date: 2006-06-14 20:06:35|
|Subject: Re: autovacuum|