470,647 Members | 1,099 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

WAL question

hi, all,

I have just read Postgresql-7.3.4 documents about WAL (write ahead
logging). But there are still something unclear to me. I'm not sure my
understanding is right. Please let me know if there is anything wrong. Thank
you all in advance.

WAL means any changes to data pages shouldn't be written to disk before
the its log record have been written to log file. If log records is written
to disk everytime the commit is performed, there is no uncommitted changes
written to database. So there is no undo action needed during recovery time.
Another alternative is flushing log buffer once it is full. In this case,
un-committed changes are possible written to databases. So undo action is
inevitable for after-crash recovery.

In postgresql-7.3.4, UNDO operation is not implemented because of a
permanent pg_clog file to hold the status of transactions. My question is
that how this trick works precisely ?

Jack Dull

Nov 11 '05 #1
0 1093

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mohammed Mazid | last post: by
3 posts views Thread by Stevey | last post: by
10 posts views Thread by glenn | last post: by
53 posts views Thread by Jeff | last post: by
56 posts views Thread by spibou | last post: by
2 posts views Thread by Allan Ebdrup | last post: by
3 posts views Thread by Zhang Weiwu | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.