Re: pg_clog & vacuum oddness

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_clog & vacuum oddness
Date: 2003-10-30 00:13:53
Message-ID: 3FA057C1.7020102@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Lane wrote:

> Jeff <threshar(at)torgo(dot)978(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message lekkala venkata praveen 2003-10-30 01:27:51 un subscribe
Previous Message Gregg Lynch 2003-10-29 20:02:55 Employment Opportunity in San Jose, Ca