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.

IT is struggling to keep up with the speed of business. The business landscape shifts priorities and requirements faster than you can say “request a change order.” As technology choices increase, so does the complexity of the decision-making process for new solutions. IT is left asking: “how can we quickly leverage new technology without introducing more complexity and risk?”

Backup strategies are critical to enterprise data management, but the time, storage, and management requirements pose a host of challenges.

Interest in Postgres has risen to equal that of MySQL and IBM DB2 based on inquiries received by industry analyst firm Gartner, according to Gartner analyst Merv Adrian, who delivered that message during a panel at the recent Postgres Vision conference. Advances in Postgres have accelerated with the pace of business and organizations are turning to the EDB Postgres Platform from EnterpriseDB® (EDB™) for flexibility and speed-to-solution offered by the open source-based solution.

In 2012, the research firm Gartner defined the Logical Data Warehouse (LDW) as “a new data management architecture for analytics which combines the strengths of traditional repository warehouses with alternative data management and access strategy.”

High availability means keeping the enterprise’s critical data infrastructure running well with virtually no downtime, and ensuring the database infrastructure’s ability to keep running in the event of failure. Enter EDB Postgres™ Failover Manager, the high availability solution from EnterpriseDB® (EDB™) that was recently enhanced with controlled switchover and switchback and new options for customized configurations. Read the release.