Re: pg_clog & vacuum oddness - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: pg_clog & vacuum oddness
Date
Msg-id 3FA057C1.7020102@bigfoot.com
Whole thread Raw
In response to Re: pg_clog & vacuum oddness  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Postgres & XML  ("Andrzej Schulz" <jaskierbard@poczta.onet.pl>)
List pgsql-admin
Tom Lane wrote:

> Jeff <threshar@torgo.978.org> writes:
>
>>given that template0 and 1 rarely change.. I don't see why we'd need to
>>vacuum them

> You have to vacuum template1 periodically if you want pg_clog to shrink.

WOW, I saved 200 MB in one shoot vacuuming template 1 !

I learned this after 2 years of postgres, I'm a dummy.



Regards
Gaetano Mendola



pgsql-admin by date:

Previous
From: Andrew Biagioni
Date:
Subject: Matching indexes on int8 columns?
Next
From: "lekkala venkata praveen"
Date:
Subject: un subscribe