| 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: | 44907961.9030809@ca.afilias.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
again.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Praveen Kumar N | 2006-06-15 04:56:59 | database physical storage |
| Previous Message | Scott Marlowe | 2006-06-14 20:06:35 | Re: autovacuum |