pgsql: Add: > > * Allow control over which tables are WAL-logged > >

Started by Bruce Momjianover 20 years ago1 messagescomitters
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Log Message:
-----------
Add:

* Allow control over which tables are WAL-logged

Allow tables to bypass WAL writes and just fsync() dirty pages on
commit. To do this, only a single writer can modify the table, and
writes must happen only on new pages. Readers can continue accessing
the table. Another option is to avoid transaction logging entirely
and truncate or drop the table on crash recovery. These should be
implemented using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP |
TRUNCATE | STABLE | DEFAULT ]. [wallog]

Modified Files:
--------------
pgsql/doc:
TODO (r1.1742 -> r1.1743)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1742&r2=1.1743)
pgsql/doc/src/FAQ:
TODO.html (r1.247 -> r1.248)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.247&r2=1.248)