Ticket #818 (closed defect: fixed)
ANALYZE does not override statistics on empty table
|Reported by:||strk||Owned by:||pramsey|
Dunno if postgis can do anything here or is a postgresql thing. What happens is that there seems to be no way to clear statistics of a table after truncating it.
Try with st_estimated_extent: fill a table, analyze, get estimated extent, truncate, vacuum and analyze again, get estimated_extent again: you'll obtain the old estimate.