Skip site navigation (1) Skip section navigation (2)

Re: Table truncate question

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Benjamin Krajmalnik <kraj(at)illumen(dot)com>
Cc: postgres <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Table truncate question
Date: 2006-06-14 21:02:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 NDate: 2006-06-15 04:56:59
Subject: database physical storage
Previous:From: Scott MarloweDate: 2006-06-14 20:06:35
Subject: Re: autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group