what are clog and xlog?

Started by flyusa2010 flyabout 15 years ago2 messages
#1flyusa2010 fly
flyusa2010@gmail.com

Hi, folks,

I'm a newbie to postgres. I'm confused with xlog and clog.
To my initial understanding, xlog is the periodic checkpoint log for data,
while clog is for commit log (very unclear for me ...)

Thanks!

#2Kevin Grittner
Kevin.Grittner@wicourts.gov
In reply to: flyusa2010 fly (#1)
Re: what are clog and xlog?

flyusa2010 fly wrote:

clog is for commit log (very unclear for me ...)

It is an important part of tracking tuple visibility.

You might want to start with this page:

http://wiki.postgresql.org/wiki/Hint_Bits

-Kevin