On Thu, Sep 1, 2011 at 10:04 AM, Rik Bellens <rik.bellens@telin.ugent.be> wrote:
>
> after running reindex on the stats_count_pkey, the disk size of this index
> was reduced with about 2 gigs, but the size of the table itself was still
> very large.
> running 'vacuum full' also reduced the table size from 14 gigs to about 2
> gigs.
> I will now regullarly check the database with the mentioned tools and
> queries.
> thank you for the very usefull tips
Excellent. keep in mind that vacuum full on a table can lead to index
bloat, so you might need to reindex after that.