log results

Поиск
Список
Период
Сортировка
От Marc Fromm
Тема log results
Дата
Msg-id B0D7C0A3F35FE144A70312D086CBCA9BF76D27AF@ExchMailbox2.univ.dir.wwu.edu
обсуждение исходный текст
Ответы Re: log results  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Evan Rempel
Дата:
Сообщение: LDAP authentication
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: log results