Re: pg_attribute size - Mailing list pgsql-admin

From Anj Adu
Subject Re: pg_attribute size
Date
Msg-id f2fd819a0910261551w194f721dv24e392f46cbb4a9a@mail.gmail.com
Whole thread Raw
In response to Re: pg_attribute size  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_attribute size  (Naomi Walker <nwalke@eldocomp.com>)
List pgsql-admin
Agreed...


Thank you

On Mon, Oct 26, 2009 at 3:46 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Anj Adu <fotographs@gmail.com> writes:
>> We have several partitioned tables that get dropped every day ..We do
>> not do autovacuum as it is an IO hog (and most tables are dropped
>> anyways..and the large tables are never updated)..
>
> If you're not going to run autovacuum then that means *you* must take
> responsibility for vacuuming everything on a reasonable schedule.
> That includes the system catalogs.  I think you'd be better off taking
> the effort to learn to tune autovacuum to fit your requirements.
>
>                        regards, tom lane
>

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_attribute size
Next
From: Tom Lane
Date:
Subject: Re: duplicate key violated errors