View previous topic :: View next topic |
Author |
Message |
pactoo Guru
Joined: 18 Jul 2004 Posts: 553
|
Posted: Tue Jun 27, 2006 1:38 pm Post subject: postgresql: transaction wrap limit |
|
|
The log of my usually quite bored postgresql rdbms has tons of log entries as follows:
Code: |
transaction ID wrap limit is 1075588879, limited by database >>postgres<<
|
This message appears for every database. I am just wondering wether this is normal or is an indication for some kind of problem. Activating autovacuum did not change anything, but the database is way too small anyway to even come remotely close to a transaction ID wraparound.
So anything to worry about? |
|
Back to top |
|
|
Beefrum Apprentice
Joined: 23 May 2006 Posts: 234
|
Posted: Tue Jun 27, 2006 2:16 pm Post subject: |
|
|
How would I know
Me thinks, they want you to alter this value so you aware of this setting. {Weirdest number I've seen.}
Once you reach this number your transaction ID's will start with the old values.
So NO ROLLBACK NO MORE. If you catch my meaning _________________ Give adaptive answers to unknown problems! |
|
Back to top |
|
|
|