Re: New to PostGre SQL asking about write-ahead-log (WAL)

On 09/16/2014 10:50 PM, Mingzhe Li wrote:
> Hi,
>
> I am new to PostGre SQL and want to ask some questions. In my database
> class, we plan to work on a class project based on WAL. Since we are not
> familiar with WAL, we don't know what's a good start point. Could anyone
> point me to any documentation mentioning about WAL in PostGre SQL?

The user manual gives a high-level overview, see 
http://www.postgresql.org/docs/devel/static/wal.html. You can also find 
some presentation slides if you google.

> It will be very helpful if anyone could point me to the file which
> includes the core of WAL implementation.

src/backend/access/transam/xlog.c. The WAL record format is best 
described by the comments around XLogRecord, in src/include/access/xlog.h.

- Heikki