| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Anibal David Acosta <aa(at)devshock(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: autovacuum, exclude table |
| Date: | 2011-12-12 14:45:24 |
| Message-ID: | CAD2md3EpKvvEwA_+ZggC0iSO5qCNZ3_eZ25N9Gc7cqLkV3FAPg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Top-posting because this is context free:
You need to provide more info for anybody to help you. Are the tables
append-only or are deletes/updates also performed? Also this:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
On Dec 12, 2011 10:26 PM, "Anibal David Acosta" <aa(at)devshock(dot)com> wrote:
> I have a couple of tables with about 400millions of records increasing
> about 5 millions per day.****
>
> ** **
>
> I think that disabling autovac over those tables, and enabling daily
> manual vacuum (in some idle hour) will be better.****
>
> ** **
>
> I am right?****
>
> ** **
>
> Is possible to exclude autovacuum over some tables?****
>
> ** **
>
> Thanks!****
>
> ** **
>
> Anibal****
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anibal David Acosta | 2011-12-12 14:55:00 | Re: autovacuum, exclude table |
| Previous Message | Anibal David Acosta | 2011-12-12 14:25:43 | autovacuum, exclude table |