The EDB Blog

PostgreSQL's Hash Indexes Are Now Cool

By Robert Haas
Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes were committed to PostgreSQL 10 which is expected to be released next week, it seems like a good time for a brief review of all the work that has been done over...

PL/Java Adoption

By Bruce Momjian
PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java language and hamper its adoption. First, there are a limited number of people who know both Java and the Postgres backend code. Fortunately Chapman Flack...

Are You Confident You’re Handling Your Postgres Project the Right Way?

By Debra Brucato
IT professionals have many new responsibilities around data management and strategy. The pace of change is very rapid in modern organizations. Database administrators and developers are joining forces. DevOps teams are now working together to rapidly develop new applications and replatform legacy...

When to Use Server-Side Logic

By Bruce Momjian
The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The question has always been what amount of logic should be encoded in the database vs. in client applications or application servers. Beyond using the...

Certify to Score Open Source Jobs

By Debra Brucato
IT hiring managers want certifications, and are willing to pay employees more for them. Those were key findings in the annual Open Source Jobs Report released recently by The Linux Foundation. Based on a survey conducted with tech career hub Dice, the report found that a growing number of hiring...

Which NoSQL Database for New Project?

By Bruce Momjian
Oh, how I love the title of this 2014 Slashdot request, "Which NoSQL Database For New Project?" The user already knows the type of clients (iPhones and Android phones) and the middleware (Php/Symfony or Ruby/Rails) and then comes the zinger, "I would like to start with a NoSQL solution for scaling...

You Don't Need Every Feature of Your Previous Database

By Bruce Momjian
In a March blog post I talked about the mismatch between what people expect from Postgres in terms of hints, and what exists. In this blog post I would like to cover the more general case of when people should expect feature parity with their previous database, and when such expectations are...

Minimizing Complexity in a Polyglot Persistence World

By Marc Linster
Data now comes in a wide variety of formats, giving rise to more heterogeneous data collections, often resulting from a commonly employed strategy of choosing the data management solution best suited for the data type and application demands. Selecting the right “horse for the course” approach...

Keeping Up with the Blistering Pace of Modern Application Development

By Taylor Graham
In my role, I frequently talk to organizations about their top priorities for their software applications. Time and again, speed to market wins the day. They consistently say that getting to market quickly with new products and features that enable real-time engagement with their customers is their...

Outer Joins and Where Clauses

By Bruce Momjian
Postgres supports both traditional join syntax , which uses the where clause to specify joined columns, and ansi join syntax, that uses the word join in the from clause. While both syntaxes can be used for inner joins, only the ansi join syntax supports outer joins in Postgres. Because column...

Walled Gardens or Beautiful Fields: A Model to Become Truly Digital

By Ed Boyajian
Think about the old days. Infrastructure software was deployed and managed on a “per server” basis. Later that moved to the socket, and then to the core, and then to the virtual core. Well, guess what? Today, people want to deploy technology in even smaller increments. For example in containerized...

Opening Day for Postgres Vision 2017

By Keith Alsheimer
The sharpest minds in data management gathered for Postgres Vision 2017 this week in Boston to begin shaping a future with open source for harvesting strategic value and actionable insight from data. The first day of discussions spotlighted open source gains in artificial intelligence, strategies...

Advanced Retention Management for Postgres Backups

By ahsan hadi
Data retention has become a greater challenge for database administrators as volumes have exploded with new digital applications and data from mobile, web, and machine sources. The sheer volume of data can limit the number of backups DBAs can perform, increasing the importance of creating defined...

Allowing Only One Null

By Bruce Momjian
While the sql standard allows multiple nulls in a unique column, and that is how Postgres behaves, some database systems (e.g. ms sql ) allow only a single null in such cases. Users migrating from other database systems sometimes want to emulate this behavior in Postgres. Fortunately, this can be...

ALTERing the Bounds of a Partition

By Ashutosh Bapat
PostgreSQL 10 is full with a lot of big, new and exciting features. Declarative partitioning is one of those. It is something users have wanted for years. During PGCon 2017 , it was a hot topic of discussion. People wanted to know more about the feature, and were eager to try it out. The...

Postgres Vision Training Day at MIT Ends with Certification

By Debra Brucato
In a 2013 McKinsey & Company global survey , 35 percent of executives said improving the talent level and capabilities of IT staff was critical for improving the performance of major IT projects. This number reflects the challenge organizations face: just as the emphasis has shifted to becoming...