Search Postgresql Archives

checkpoint logs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm logging checkpoints to see how the background writter is working,
and I bumped into log information that I don't fully understand:

LOG:  checkpoint complete: wrote 5015 buffers (15.1%); 0 transaction
log file(s) added, 0 removed, 15 recycled; write=1004.333 s,
sync=0.106 s, total=1004.571 s

5015 are the WAL buffers written to the transaction log, but what is the 15.1%?

Also, what do the times at the end mean? Time to write the buffers to
the transaction log, or to flush modificactions stored in the
transaction logs to there final destination in the data base files?

-- 
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux