Re: checkpoints anatomy

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Mon, 12 Oct 2015 09:35:34 +0300



    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