Table truncate question

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: "postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: Table truncate question
Date: 2006-06-14 16:34:32
Message-ID: BF337097BDD9D849A2F4B818DDB27987029336@stash.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sriram Dandapani 2006-06-14 16:52:48 autovacuum
Previous Message Rojas, Fernando (CIAT) 2006-06-14 16:02:48 FW: Error starting backend