Re: Autovacuum ideas

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: Brendan Duddridge <brendan(at)clickspace(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Autovacuum ideas
Date: 2006-04-13 06:55:55
Message-ID: 79FBF84D-29B6-42CB-845E-E588FBEA86E9@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 13.04.2006, at 7:56 Uhr, Brendan Duddridge wrote:

> What I'd like to see is a table exclusion list. I have a few very
> large history tables that are never updated or deleted, only
> inserts and selects.

But if you do selects regularly you may want to have the analyse part
of autovacuum for this tables. Or you can analyse on a nightly basis
- perhaps it's good enough.

cug

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Robin Iddon 2006-04-13 07:36:43 Re: Autovacuum ideas
Previous Message Brendan Duddridge 2006-04-13 05:56:47 Re: Autovacuum ideas