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 616339F9FE3 for ; Wed, 14 Jun 2006 13:34:51 -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 38391-01 for ; Wed, 14 Jun 2006 13:34:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 2E7D89F9CAA for ; Wed, 14 Jun 2006 13:34:37 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C68FD0.6A46BDEB" Subject: Table truncate question X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Wed, 14 Jun 2006 10:34:32 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Table truncate question Thread-Index: AcaPu6TLcS+3aEhETKyGV9o/0qW5TAAFGQ8Q From: "Benjamin Krajmalnik" To: "postgres" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/121 X-Sequence-Number: 22083 This is a multi-part message in MIME format. ------_=_NextPart_001_01C68FD0.6A46BDEB Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable 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. =20 I am running PG 8.1.4 on Windows. =20 ------_=_NextPart_001_01C68FD0.6A46BDEB Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

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.

 

------_=_NextPart_001_01C68FD0.6A46BDEB--