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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers