LXer: How to optimize PostgreSQL database size
 

Published at LXer:

One of the PostgreSQL's most sophisticated features is so called Multi-Version Concurrency Control (MVCC), a standard technique for avoiding conflicts between reads and writes of the same object in database. Unfortunately, there is one downside to MVCC, the databases tend to grow over time. This article shows two ways to get your space back!

Read More...