log results - Mailing list pgsql-admin

From Marc Fromm
Subject log results
Date
Msg-id B0D7C0A3F35FE144A70312D086CBCA9BF76D27AF@ExchMailbox2.univ.dir.wwu.edu
Whole thread Raw
Responses Re: log results
List pgsql-admin

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.

 

thanks

 

 

 

 

Marc

 

pgsql-admin by date:

Previous
From: Evan Rempel
Date:
Subject: LDAP authentication
Next
From: "Scott Marlowe"
Date:
Subject: Re: log results