Postgres Pro
Downloads
Home   >   mailing lists

Table truncate question - Mailing list pgsql-admin

From Benjamin Krajmalnik
Subject Table truncate question
Date
Msg-id BF337097BDD9D849A2F4B818DDB27987029336@stash.stackdump.local
Whole thread Raw
Responses Re: Table truncate question  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-admin
Tree view

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.

 

pgsql-admin by date:

Previous
From: "Rojas, Fernando \(CIAT\)"
Date:
Subject: FW: Error starting backend
Next
From: "Sriram Dandapani"
Date:
Subject: autovacuum