The EDB Blog
December 31, 2018

As we approach year-end, we were inspired to take a look back at our posts from the past year and see what topics resonated the most. Here is a Top 10 recap of your favorites from 2018.

 

10. Is ACID a Priority or Not? Can MongoDB Decide?

This summer, MongoDB announced support for multi-document ACID transactions in MongoDB 4.0. This development started a discussion, as it was still unclear whether ACID was really a priority for them.

 

9. Encryption Module in EDB Postgres Earns FIPS 140-2 Validation

Next up was the exciting news that EDB Postgres earned the FIPS 140-2 Validation, because security holds steady as a top concern for organizations of all sizes!

 

8. Zheap: A Storage Engine to Provide Better Control Over Bloat

News of the potential game changer, zHeap, as a popular post as well! zHeap is a new storage engine that will enable better control of bloat. We think zHeap is pretty cool, and obviously you did too! Did you know that if you put a Z in front of anything, it makes it cooler? See what we did there?

 

7. Parallel Hash for PostgreSQL

In this post, Thomas Munro tells the story of his work on Parallel Hash for PostgreSQL, the biggest feature he’d worked on in PostgreSQL up to that point. Thomas took up the project at the encouragement of Robert Haas, because he implied it “seemed pretty easy”. Hah!

 

6. Best of Both Worlds: Integrating Pgpool with EDB Postgres Failover Manager

A commonly asked question among our customers is how best to integrate Pgpool and EFM. This popular post secured our #6 spot by offering an informative how-to for automating the Pgpool update should EFM execute a Master failover.

 

5. Untangling Years of Layered Legacy Systems

Legacy IT systems dominate many institutions, and it is safe to say that highly customized applications are a major issue. This post secured our #5 spot by resonating with many readers seeking to untangle from legacy and build new applications on open source-based platforms.

 

4. Partition-wise Joins: “Divide and Conquer" for Joins Between Partitioned Table

Partition-wise joins divide and conquer, but such features require the work of a team to make them a reality—from authoring, testing, and benchmarking, to committing and reviewing. If you missed it, read more to learn about the commitment of basic partition-wise join.

 

3. Ready to Test Your Postgres Skills?

Clearly, our readers place a high priority on education and self-improvement! When we released our PostgreSQL 10 Associate Certification, people took notice. Securing our #3 spot, this post explains the great opportunities available to put your skills to the test and earn industry recognized Postgres certifications.

 

2. Creating a Data Redaction Capability to Meet GDPR Requirements Using EDB Postgres

Nothing like the threat of a staggering fine to catch your attention! So, it's no surprise that this post clinches our #2 spot on the count down. This post discusses how to use EDB Postgres Advanced Server 10 to create a data redaction capability to meet GDPR requirements. And as a follow-on, check out this most recent post about the native data redaction capability in EDB Postgres Advanced Server 11.

 

1. Meltdown and Spectre Vulnerabilities Explained

And what could be worse than a fine? An exploit of course! Our readers appreciated our post explaining the Meltdown and Spectre vulnerabilities and how to mitigate potential risk.

 

There you have it. 2018 is a wrap. We thank you for all your readership in 2018, and look forward to continuing the conversation in 2019. Tell us what you want to hear about in the new year. What are your business priorities? What technical questions do you want to explore? Send us your comments and feedback. We blog for you.

 

Happy New Year from the team at EDB!