The Design Of The Postgres Storage System (1987)
Cached
Download Links
- [www.unfortu.net]
- [s2k-ftp.cs.berkeley.edu:8000]
- [db.cs.berkeley.edu]
- DBLP
Other Repositories/Bibliography
| Citations: | 155 - 12 self |
BibTeX
@INPROCEEDINGS{Stonebraker87thedesign,
author = {Michael Stonebraker},
title = {The Design Of The Postgres Storage System},
booktitle = {},
year = {1987},
pages = {289--300}
}
Years of Citing Articles
Bookmark
 |
 |
 |
 |
 |
 |
OpenURL
Abstract
This paper presents the design of the storage system for the POSTGRES data base system under construction at Berkeley. It is novel in several ways. First, the storage manager supports transaction management but does so without using a conventional write ahead log (WAL). In fact, there is no code to run at recovery time, and consequently recovery from crashes is essentially instantaneous. Second, the storage manager allows a user to optionally keep the entire past history of data base objects by closely integrating an archival storage system to which historical records are spooled. Lastly, the storage manager is consciously constructed as a collection of asynchronous processes. Hence, a large monolithic body of code is avoided and opportunities for parallelism can be exploited. The paper concludes with a analysis of the storage system which suggests that it is performance competitive with WAL systems in many situations. 1. INTRODUCTION The POSTGRES storage manager is the collection of...
