Postgres Pro
Downloads
Home   >   mailing lists

Re: Large historical tables and autovacuum - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: Large historical tables and autovacuum
Date
Msg-id CAFnxYwgdDTMzYKjcK8q6YxJmCR+bLU+Wezx7wx7fHBr7Pi0m4g@mail.gmail.com
Whole thread Raw
In response to Re: Large historical tables and autovacuum  (David Morton <davidmorton78@gmail.com>)
List pgsql-admin
Tree view 
On Mon, Sep 10, 2012 at 9:04 PM, David Morton <davidmorton78@gmail.com> wrote:
> Is there any way of making the table 'read only' so its nice and tidy /
> immutable ?

Once a table actually *is* read-only, you can VACUUM FREEZE it.

rls

--
:wq

pgsql-admin by date:

Previous
From: David Morton
Date:
Subject: Re: Large historical tables and autovacuum
Next
From: "Albe Laurenz"
Date:
Subject: Re: Large historical tables and autovacuum