I just started logging postgresql. In the log are these entries:
478 LOG: transaction ID wrap limit is 1110972072, limited by database "cswe2"
479 LOG: transaction ID wrap limit is 1110972072, limited by database "cswe2"
480 NOTICE: number of page slots needed (27072) exceeds max_fsm_pages (20000)
481 HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 27072.
Can someone explain what it is and what I need to do to fix it?
I searched online and found references to performing a vacuum on the databases. That is already being done on a nightly basis prior to the backup.
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2008-10-08 23:13:10|
|Subject: Re: log results|
|Previous:||From: Evan Rempel||Date: 2008-10-08 22:02:12|
|Subject: LDAP authentication|