Re: PostgreSQL 64 Bit XIDs - Transaction IDs

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Gerhard Wiesinger <lists(at)wiesinger(dot)com>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 64 Bit XIDs - Transaction IDs
Date: 2012-03-23 19:35:16
Message-ID: 4F6CD074.7080801@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 03/23/2012 12:12 PM, Gerhard Wiesinger wrote:
> On Fri, 23 Mar 2012, John R Pierce wrote:
>
>> On 03/23/12 9:17 AM, Gerhard Wiesinger wrote:
>>> So in that time autovacuum is triggered.
>>
>> autovacuum runs pretty much continuously in the background, its not an
>> on/off thing.
>
> Yes, I know. I ment that it runs at least once in 1.5 days.

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

>

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yuanyuan Tian 2012-03-23 22:31:17 about numerical accuracy of statistical functions
Previous Message david.sahagian 2012-03-23 19:29:34 Change the default [tgenabled] for new "internal" triggers ?