On Thu, Sep 1, 2011 at 10:04 AM, Rik Bellens <rik.bell...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
