The 2017 Gartner Magic Quadrant for Operational Database Management Systems (OPDBMS) packed a couple of surprises.

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 is known as the most flexible and extensible DBMS...

Licensing complexity, rising costs, and audit risk are motivating Oracle customers to jump start their migration efforts to alternative database platforms.

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 data retention policies in the database platform. Enterprises typically take backups (full or...

Middleware can have a significant impact on the operation and performance of the database system. Pgpool-II is the middleware product that sits between the PostgreSQL server and database clients and is developed and maintained by a committed open source Postgres community that includes EnterpriseDB employees. A major version of Pgpool-II is released every year and the latest is Pgpool-II 3.6...

PostgreSQL have supported Hash Index for a long time, but they are not much used in production mainly because they are not durable. Now, with the next version of PostgreSQL, they will be durable. The immediate question is how do they perform as compared to Btree indexes. There is a lot of work underway for the coming version to make them faster. There are multiple ways in which we can compare the...

Polyglot persistence is based on the assumption that there is no single database technology that suits all data needs equally. Hence different types of data need to be handled and stored differently in order to provide the best possible performance while offering appropriate availability.

It's exciting times in PostgreSQL for those who are using postgres_fdw or Foreign Data Wrappers (FDWs) in general. Users often complained that a simple count(*) on a foreign table was slow since PostgreSQL required to pull all the rows from the foreign server just to count them to produce count(*). “What a waste of resources,” they complained, “Why doesn’t it just get the count from the foreign...

The accelerated pace of application development means most enterprises can no longer wait for traditional IT to lead those initiatives. Traditional IT practices that required provisioning hardware and software, configuring the network, and essentially recreating resources that developers need repeatedly for new projects cannot support DevOps models of application delivery.

I recently went to PGConf.EU, the European PostgreSQL conference that was held in Tallinn, Estonia on November 1-4. This annual event for Postgres developers and users is a great opportunity to learn what everyone has been and will be working on.