This blog describes rewriting behavior changes in PostgreSQL 11.

We most likely will not be upending anyone’s world-view if we make the claim that database spend is a big slice of IT’s overall costs, and one that many businesses would love to shrink.

Licensing complexity, rising costs, and audit risk are motivating Oracle customers to jump start their migration efforts to alternative database platforms, like open source-based Postgres. Gartner has recommended that chief data officers and CTOs, “add open-source RDBMSs...for new uses, and to replace commercial RDBMSs where these are not specifically required”, and two of the factors driving that recommendation are low TCO and fast ROI.

In PostgreSQL 11, a new functionality of autoprewarm has been added into the contrib module pg_prewarm. This automatically warms the shared buffers with the same pages held before the last server restart.

InMobi, one of the fastest growing global mobile advertising networks, delivers results to its partners through intelligent mobile advertising solutions. The advanced technology enables advertisers to discover their target audience on mobile Internet sites and mobile applications in a measurable manner.

Database administrators need tools for database maintenance, performance optimization, configuration, and highly availability. EnterpriseDB (EDB) leads the industry in creating best-in-class Postgres tools to support DBAs with their mission critical enterprise deployments.

Choosing a database solution is one of the most important decisions for a company that is rolling out a website or developing a new in-house application. The open-source version of PostgreSQL can be a good option for small companies. But enterprise-level database applications often require more tools and capabilities in order to scale.

PostgreSQL has advanced in terms of features, performance, and scalability for many core systems. However, one of the problems that many enterprises still complain about is bloat.

The rate of adoption of cloud services among central and local government, and other public sector bodies, is clearly on the increase, which is not surprising given the UK Govt Cloud First strategy.

EDB Postgres Failover Manager (EFM) supports multiple ways to connect applications with the new master database after a failover or promotion. In many cases, a virtual IP address (VIP) can be used, and Failover Manager will move the VIP as needed. On cloud providers where the VIP is not an option, script hooks can be used to move a resource (e.g. an Elastic IP Address on AWS) to the new master node.