Alan Stange <[EMAIL PROTECTED]> writes: > INFO: "tbltimeseries": found 8610108 removable, 26165807 nonremovable > row versions in 5744789 pages > DETAIL: 0 dead row versions cannot be removed yet. > There were 235555635 unused item pointers. > 0 pages are entirely empty.
The item pointers themselves are not very interesting --- at 4 bytes apiece, they're only accounting for 2% of the table space. However the fact that there are nearly 10x more unused than used ones suggests that this table is suffering a pretty serious bloat problem. Assuming constant-width rows in the table, that implies something like 90% of the space in the table is unused. (contrib/pgstattuple might be useful to confirm this estimate.) VACUUM FULL, or perhaps better CLUSTER, would get you out of that. And yes, you will need to vacuum more often afterwards if you want to keep the bloat under control. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly