Обсуждение: 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

On 09/17/2014 03:50 AM, 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? It
> will be very helpful if anyone could point me to the file which includes
> the core of WAL implementation. Any advice along this line is very welcome. 

This appears to be a re-post of
http://stackoverflow.com/q/25876287/398670 to -hackers.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services