Обсуждение: performance issues and default settings

Hi -

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? We have autovacuuming turned on with the default configuration.

Thanks for the help!
Mija

Mija Lee <mija@scharp.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