Re: Why is plan (and performance) different on partitioned table? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Why is plan (and performance) different on partitioned table?
Date
Msg-id 26842.1146601672@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why is plan (and performance) different on partitioned table?  ("Mark Liberman" <mliberman@mixedsignals.com>)
List pgsql-performance
"Mark Liberman" <mliberman@mixedsignals.com> writes:
> Now, the potentital bug:
> It appears that after you truncate a table, the statistics for that =
> table still remain in pg_statistics.

That's intentional, on the theory that when the table is re-populated
the new contents will probably resemble the old.

            regards, tom lane

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: postgresql transaction id monitoring with nagios
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Performance Issues on Opteron Dual Core