News for hackers. Stuff that matters.

A comment on What's Coming in PostgreSQL 9.5. Parent comment

Re:What's Coming in PostgreSQL 9.5 by tiwazz on Thursday July 02, 2015 @02:51PM (#9820812)
Try 6NF[0], not only do you get separate logging for when the row was/will be marked deleted, but you have a record of when the DB believed that the record was/will be deleted. Also true history and rewind capability.

[0] https://en.wikipedia.org/wiki/Sixth_normal_form

[ Parent | on HN ]
Re:What's Coming in PostgreSQL 9.5 by bmh100 on Friday July 03, 2015 @03:03PM (#9827348)
Right, thank you for reminding me about the term. I like to see databases that generally follow this strategy, while providing higher-speed access to current data through materialized views [1].

[1]: https://en.wikipedia.org/wiki/Materialized_view

[ Parent | on HN ]