Follow the EnterpriseDB Blog for the latest on all things EDB Postgres. From news to how-tos, our community of PostgreSQL experts is always sharing leading-edge insights.
By Keith Alsheimer
As we approach year end, our EDB team was inspired to take a look back at our blog posts from the year and see what topics resonated the most with our readers. Here is a Top 10 recap of your favorites from 2017. 10. Pgpool II Keeps Pace With Demands of Today’s Architectures and Workloads This blog is about Pgpool II, the middleware product that...
MORE
By Robert Haas
Experienced PostgreSQL users and developers rattle off the terms “MVCC” and “VACUUM” as if everyone should know what they are and how they work, but in fact many people don’t. This blog post is my attempt to explain what MVCC is and why PostgreSQL uses it, what VACUUM is and how it works, and why we need VACUUM to implement MVCC. In addition, I’...
MORE
By Devrim Gündüz
The increasing deployment of Postgres has brought about new demands for features, capabilities, and tools from developers and database administrators. As the leading Postgres database platform company, EnterpriseDB® (EDB™) works closely with customers to respond to their emerging needs. One of the most important contributions EDB makes to the...
MORE
By Richard Yen
This article is about using pg_stop_backup() when setting up Streaming Replication. It is not an article about backup/restore methodology or policy. Introduction In a recent support case, I came across a customer who used a clever way to create streaming replication base backups–by taking a Google Cloud instance and cloning it. With the...
MORE
I have been with the project long enough to remember how the project got the name "PostgreSQL". In 1996, we inherited the name "Postgres95" from the Berkeley team's remaining member Jolly Chen. Obviously the Postgres95 name wasn't going to last long-term, so a new name had to be chosen. We could revert to the original Berkeley name "Postgres", or...
MORE
By Bruce Momjian
Postgres Alerts It is cool to be able to stare at colorful graphs to see what Postgres is doing, but sometimes you just want to setup something, walk away, and be informed when there is problem. That is what check_postgres and tail_n_mail are designed to do. check_postgres is a script designed to be run from cron or a monitoring tool like Nagios...
MORE
By Ken Rugg
The 2017 Gartner Magic Quadrant for Operational Database Management Systems (OPDBMS) packed a couple of surprises. High-flying NoSQL vendor MongoDB was gone. Plenty of other vendors had disappeared too. In fact, there were only 11 vendors included, down from 31 in the 2015 report—a 65% decrease. Still recognized in the report was EnterpriseDB (EDB...
MORE
By Bruce Momjian
During research for my Postgres Window Magic talk, I studied the unusual behavior of percent_rank and cumm_dist (cumulative distribution). The Postgres documentation wasn't helpful. I finally came up with this paragraph to add to the Postgres 10 docs: cume_dist computes the fraction of partition rows that are less than or equal to the current row...
MORE
By Keith Alsheimer
Would Beyoncé still be Beyoncé if she couldn’t sing? She would of course technically be the same person, but think of how different her life would be based on whatever career choice her other skills might define. The same is true for Postgres. If you take away its most powerful and unique capabilities, does it become something different? Postgres...
MORE
By Bruce Momjian
In a previous blog entry I suggested storing the original time zone offset in a separate column if clients need to know the stored time in the original time zone. There is some more complexity to this issue that I would like to cover. First, when I suggested using select extract(timezone from current_timestamp), I assumed the user was also...
MORE