Re: Too frequent warnings for wraparound failure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Too frequent warnings for wraparound failure
Дата
Msg-id 3233.1110559211@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Too frequent warnings for wraparound failure  ("Milen A. Radev" <milen@securax.org>)
Список pgsql-admin
"Milen A. Radev" <milen@securax.org> writes:
> Tom Lane wrote:
>> So you managed to execute about 6000 transactions in those two seconds.
>> Doing what?

> Well that could be the problem - I'm 99.99% positive we do not execute
> so many transactions - may be 30-40 thousand per day and that's only for
> one relatively busy DB. The example database ("xxx1") you've chosen is
> not used at all. As most of the other databases in that cluster.

It doesn't matter --- all the age counts are going up at exactly the
same rate.  Somewhere you've got a client that's issuing dummy
transaction starts at an insane rate.  Some attention to "top" output
on the server might help identify it ;-)

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: Restoring a Dump with psql on Windows Fails - Password Cannot Be Entered (?)
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] PostgreSQL pam ldap document