Re: performance issues and default settings

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mija Lee <mija(at)scharp(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: performance issues and default settings
Date: 2007-09-06 19:02:20
Message-ID: 590.1189105340@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Mija Lee <mija(at)scharp(dot)org> writes:
> I've read the section about transaction ID wrapping, but I'm not quite sure how to interpret this message in the log:

> 2007-09-06 01:45:09 PDT LOG: transaction ID wrap limit is 1083315433, limited by database "dfmt_kleemann1"

> Should I be concerned about this?

No; that's a pretty typical log message. (I think we dialed it down to
DEBUG1 or so for 8.3, because it's not really very interesting.) If you
weren't using autovacuum you might have to watch the numbers a bit more
closely.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message yanot panara 2007-09-08 01:05:56 Need help configuring PAM
Previous Message Mija Lee 2007-09-06 16:59:16 performance issues and default settings