Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group