X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 965AE9FA5C8 for ; Wed, 14 Jun 2006 18:02:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 71263-07 for ; Wed, 14 Jun 2006 18:02:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 0F4FB9FA3D7 for ; Wed, 14 Jun 2006 18:02:28 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1FqcVO-0007m8-4u; Wed, 14 Jun 2006 17:02:26 -0400 Message-ID: <44907961.9030809@ca.afilias.info> Date: Wed, 14 Jun 2006 17:02:25 -0400 From: Brad Nicholson User-Agent: Thunderbird 1.5.0.4 (X11/20060516) MIME-Version: 1.0 To: Benjamin Krajmalnik CC: postgres Subject: Re: Table truncate question References: In-Reply-To: X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/124 X-Sequence-Number: 22086 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.