Re: checkpoints anatomy

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: checkpoints anatomy
Дата
Msg-id 561B54B6.6030504@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на checkpoints anatomy  (Richardson Hinestroza <richardhinestroza@gmail.com>)
Список pgsql-general
Дерево обсуждения
http://dba.stackexchange.com/questions/61822/what-happens-in-postgresql-checkpoint

and the now classic :
http://www.depesz.com/2011/07/14/write-ahead-log-understanding-postgresql-conf-checkpoint_segments-checkpoint_timeout-checkpoint_warning/

On 12/10/2015 04:39, Richardson Hinestroza wrote:
Hello, excuse me for my poor english. i am writting from Colombia and i am postgresql fan.

I want to know if postgresql checkpoints prevent current transactions to write the same page being flush to disk by checkpoint proccess.

And I want know if the postgresql checkpoint use the ARIES algorithmo. and known technical details about postgresql checkpoints.

i can not foud in the web answers for my question. 

i would apreciate your answer. thanks a lot


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

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

Предыдущее
От: rob stone
Дата:
Сообщение: Re: *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?
Следующее
От: "Steve Petrie, P.Eng."
Дата:
Сообщение: Re: *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?