Sirius Blog: You ask, we answer!

  • An Introduction to PostgreSQL - Part 1

    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!

    Read more

  • How Much Does Open Source Cost?

    Demystifying Open Source Costs: Strategic Investment, Not Just "Free" Software

    When exploring open source, the first question is often: "How much will this actually cost?" At Sirius, we understand. Budget clarity is crucial for planning successful deployments. We'll cut through the "free" myths and provide realistic cost ranges, empowering you to make informed decisions.

    Read more

  • A Field Guide to Linux Support Problems

     

    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:

    Read more

  • An Introduction to PostgreSQL - Part 3

    In Part 1 we looked at how PostgreSQL handles data concurrency, MVCC, and learned that understanding MVCC is critical for understanding PostgreSQL. Part 2 continued with MVCC and focused on concurrent access.

    Read more

  • An Introduction to PostgreSQL - Part 4

    In the first two articles we examined vacuums, clusters and freeze. In this third and final piece we look at indexes and backups.

    What are indexes and backups?

    An index, like in a book, is a separate set of information that tells us what is where and saves having to re-read the whole book to find something. PostgreSQL uses indexes for a similar reason and broadly in a similar way.

    Read more