Lingering Checkpoint Process

Поиск
Список
Период
Сортировка
От Cory Vokey
Тема Lingering Checkpoint Process
Дата
Msg-id D93992E093AA034F8D6BED008B91614B01A07785@XCH30YKF.rim.net
обсуждение исходный текст
Ответы Re: Lingering Checkpoint Process  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin

Hi all, I’m seeing a checkpoint process lingering around for ~ 24hrs on one of my test systems and WAL logs are accumulating.  It’s running postgres 7.4.6.

 

Research up to date indicates faulty memory or disks. 

 

Has anyone else seen this behavior?  Previously, I had to re-init the DB for this to go away, but this is obviously not the permanent solution.

 

Tks.

 

 --

Cory Vokey

BIS Database Engineering

Research In Motion Limited

185 Columbia Street, RIM3

Waterloo, ON, Canada, N2L 5Z5

519-888-7465, x3772

 


This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful.

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

Предыдущее
От: "Anjan Dave"
Дата:
Сообщение: logging time with queries
Следующее
От: FBaron@co.belcorp.biz
Дата:
Сообщение: Question