Postgres Pro
Downloads
Home   >   mailing lists

Re: Try to understand VACUUM and its settings - Mailing list pgsql-general

From Jim Nasby
Subject Re: Try to understand VACUUM and its settings
Date
Msg-id 56155C7A.5040907@BlueTreble.com
Whole thread Raw
In response to Try to understand VACUUM and its settings  (Michael Chau <michael.chau@gameyourgame.com>)
List pgsql-general
Tree view 
On 10/5/15 5:00 PM, Michael Chau wrote:
> So, do I need to run vacuum freeze on those tables? Also, if
> autovacuum_freeze_max_age is commented, does it still mean that the
> default is 200M?

Yes, and unless you're running a very high transaction rate you probably
don't need to mess with it. Likewise you normally don't need to
explicitly freeze, though it's not a bad idea to do so after a large
data load. Just make sure that there's no open transactions that were
started before the data load transaction when you run the VACUUM.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Shouldn't "WHEN (OLD.* IS DISTINCT FROM NEW.*)" clause be independent from data type?
Next
From: Jim Nasby
Date:
Subject: Re: md5(large_object_id)