Re: huge price database question..

On 03/21/2012 09:34 AM, Jim Green wrote:
> On 21 March 2012 11:01, Steve Crawford<scrawford(at)pinpointresearch(dot)com> wrote:
>> Something sounds wrong, here. XID wraps around somewhere around 4-billion
>> transactions which is a substantial multiple of the entire number of records
>> you are trying to insert. Do you have any unusual vacuum settings?
>
> I have autvacumm=off in my config and I still get autovacuum process..
> but yes, I don't have 4 billion inserts till now.. I have attached my
> config used to do bulk loading at the end..

Basically it runs as a safety check. For more info see below:

http://www.postgresql.org/docs/9.1/interactive/runtime-config-autovacuum.html

autovacuum (boolean)

Controls whether the server should run the autovacuum launcher
daemon. This is on by default; however, track_counts must also be
enabled for autovacuum to work. This parameter can only be set in the
postgresql.conf file or on the server command line.

Note that even when this parameter is disabled, the system will
launch autovacuum processes if necessary to prevent transaction ID
wraparound. See Section 23.1.4 for more information.

Section 23.1.4 where you can all the details:

http://www.postgresql.org/docs/9.1/interactive/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com