Обсуждение: New to PostGre SQL asking about write-ahead-log (WAL)
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.
Thanks,
Mingzhe
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