Sirius Blog: You ask, we answer!
Originally published back in October 2012, this classic article series is undergoing a facelift and update!
We often get asked about PostgreSQL, and especially how it compares with proprietary enterprise-class Databases like Oracle or MS-SQL. In this classic series, revised and updated for today's PostgreSQL, we get right under the hood and explain, in plain English, just how the world's greatest Open Source Database works... You ask, we answer!
What are vacuums?
Vacuums are the equivalent of taking the deletions off your sheet of notes and leaving spaces. Assembling the full set of notes afterwards is still quite difficult because the notes will be scattered all over the surface of the paper in an order that will appear less and less clear as time goes by.
One of the first questions potential Open Source customers want to know when they start the research process is How much does Open Source (support/consultancy/training/systems integration) cost? Here at SiriUS, I'd imagine we get this question hundreds and hundreds of times a year, usually within the first few minutes of the first conversation.
Here at Sirius we hear a lot from our customers and prospective customers about the kinds of problems they have with Linux and especially Linux Support.
These are a few of them:
In our first article we looked at vacuums and clustering. In this article we review FREEZE.
What is a FREEZE?
A freeze is an essential system maintenance task. If you do not run it when it is due, your system will shut down and you will be forced to run a freeze in single user maintenance mode. Because of this FREEZE is included in the VACUUM set, though it is actually dealing with logical consistency, not freeing any physical space.