The EDB Blog

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.

Is ACID a Priority or Not? Can MongoDB Decide?

By Ken Rugg
Can MongoDB make a decision?
If I’m honest, I think of MongoDB as more of a “data store” than an actual database. This may be a controversial opinion these days, but I don’t think it’s a hard position to support. Granted, MongoDB does a great job storing data for a particular use case and can be highly optimized for that purpose. But, as applications inevitably evolve, Mongo’s single-use case formula, where applications leverage the document store to optimize one access path to the data, starts to unravel.

The Changing Role of the Database Administrator

By Ken Rugg
DBAs' roles are changing
Not that long ago, the role of the DBA was comprised of a lot of mechanical tasks, including upgrades, basic system maintenance, backups and recovery, monitoring, performance tuning, and troubleshooting. With the advent of the cloud, automation and DevOps, the DBA’s role and responsibilities are...

Nested Subprocedures

By Jeevan Chalke
Planet image
As the name suggests, a nested subprocedure allows us to write a function or procedure nested within another function or procedure. It means a function can have another function within it, just like its own variable. And, as this inner function is part of the outer function, it has no visibility outside the function that encloses it.

Using Toad Edge Preview 2.0.0 with EDB Postgres 10

Quest Software recently released Toad Edge 2.0, which adds support for PostgreSQL and EDB Postgres. This reduces the time that DBAs and developers need to spend managing their Postgres databases, while ensuring optimal performance. This post was recently shared in the Toad Edge Community, which...

What Is Involved in Migrating Database Workloads to the Cloud?

By Ken Rugg
Navigating the maze to cloud
Picking up on our last post on moving databases to the cloud , now, let’s look at what is involved with migrating your database workload to the cloud. To migrate to a different database, you may need to change the schema to accommodate the new database. In moving between different relational...

Using force_parallel_mode Correctly

By Robert Haas
Are you using force_parallel_mode correctly?
I admit it: I invented force_parallel_mode. I believed then, and still believe now, that it is valuable for testing purposes. Certainly, testing using force_parallel_mode=on or force_parallel_mode=regress has uncovered many bugs in PostgreSQL's parallel query support that would otherwise have been...

Performance of parallel index scans in PostgreSQL

By Rafia Sabih
Parallel Index Scans
This blog will continue the discussion of parallel query in PostgreSQL. In the previous blog of this series, we learned about parallel index scans, its design in PostgreSQL and the performance improvement achieved for a few queries on the industrial benchmark of TPC-H. Therein we analyzed the...

Can My Database Move to the Cloud?

By Ken Rugg
Moving to the cloud
With so many workloads being migrated to the cloud, this is a question we get all the time. For anyone making this move there are many choices to make and options to consider. In this post, I will step through those to help you decide on a path forward. First, recognize that not every workload is...

EDB Postgres Summer School Tour

By Bruce Momjian
I have been in Europe now for more than two weeks meeting a number of our customers and PostgreSQL users at the EDB Postgres Summer School. So far I have been in Zürich, London and Oslo and there are further events in the Netherlands, France, Czech Republic, Italy, and Belgium, the Nordics, Spain...

Databases in the Cloud: Today's Realities and Tomorrow's Promise

By Ken Rugg
EDB recently had the pleasure of inviting Noel Yuhanna to present at a webinar we hosted— Databases in the Cloud: Today's Realities and Tomorrow's Promise . Yuhanna is a principal analyst at Forrester, serving enterprise architecture professionals. This webinar was well attended, and that was no...

Upgrade your Partitioning from Inheritance to Declarative

By Ashutosh Bapat
Partitioning
Before PostgreSQL 10, Postgres users partitioned their data using inheritance based partitioning. The method used constraints to define the partitions and rules or triggers to route the data to appropriate partition. A user had to write and maintain code for all of that. PostgreSQL 10 introduced...

Planning Queries Involving Foreign PostgreSQL Tables

By Ashutosh Bapat
Cost based optimization A query may be executed in many different ways, modeled as plans in the query optimizer, differing in resources required and/or execution time. A typical DBMS's query optimizer tries to find all of the possible plans for executing a given query and chooses the fastest plan...

PGDay Comes to Amsterdam

By Devrim Gündüz
Amsterdam
Thought it would be good to make everyone aware that PGDay is coming to Amsterdam for the first time on July 12th and I’m delighted to say I will be there helping to host the day, as well as presenting on Write-Ahead Log (WAL). If you want to find out more you can go to this link . The event will...

Default Partition - Adopting the Odds

By Jeevan Ladhe
Partitioning
PostgreSQL 10 introduced declarative partitioning, which included list and range partitioning. But, it had always been an open question as to what happens if we get rows which do not qualify to be placed in any of the given list/range partitions. That's when PostgreSQL 11 introduces a solution to...

4 Ways to Integrate EDB Postgres Using Popular Interfaces

By Eric McCormack
Connectors
EnterpriseDB supports a wide array of connectors to integrate your application with EDB Postgres, and our Connectors team has been hard at work, just releasing our Connectors 10.0.2 update. This release made a host of enhancements to all four supported connectors. In this post, I’ll bring you up to...