Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

WAL files and heckpoints



Hi all

We have been 'fighting' with the performance of our app for some days now.We don't know exactly how wal log files and check points exactly work behind scenes.
We found that incrementing the checkpoint_segments and increasing the wal_buffers the performance of our app goes up.
Our app is primarily  inserts , we don't do deletes at all and updates happen just eventually.
We have two understanding on this 

1 )So once a transaction is comitted , it goes to the wal_buffers then when a checkpoint_segment comes or a time_out comes , wal_buffers is flush out to the disk into the logfiles?
Is that correct?, If so, what happens if the system crash before a checkpoint occurs? we lost the log files?.

2) Transactions go to the WAL buffers then when the check_point comes , wal_buffers are written to the D.B. and to the logfiles
if so what happen when the system crash before the wal_buffers are written do the D.B/

Could u please clarify that process?

Thanks a lot in advance








Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group