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