The EDB Blog

Controlling Autovacuum

By Bruce Momjian
Unlike other database systems, Postgres makes the cleanup process visible and tunable to users. Autovacuum performs recycling of old rows and updates optimizer statistics. It appears in ps command output, the pg_stat_activity system view, and optionally in the server logs via...

Achieving Polyglot Persistence through Data Integration in the Cloud

By Sandra Wiecki
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. This...

PostgreSQL: Aggregate Push-down in postgres_fdw

By Ashutosh Bapat
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...

EDB Ark: DBaaS for Hybrid Cloud Deployments

By Pierre Fricke
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...

Partition Pruning in EDB Postgres 9.5

By Vibhor Kumar
One of my colleagues who was recently working with a customer has presented a customer case. According to him, the customer has a partitioned table and EDB Postgres™ was not applying the partition pruning in his query. So, I thought to blog about partition pruning, so that EDB Postgres developers...

Collaboration Makes Postgres Better for Everyone

By Sandra Wiecki
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 always amazes me how this open source community...

5 Step Assessment: Selecting a DBMS for New Application Development

By Matt Cicciari
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...

Data Backup Made Easy

By ahsan hadi
Backup strategies are critical to enterprise data management, but the time, storage, and management requirements pose a host of challenges. Because companies are managing huge volumes of data, which continue to grow daily, the amount of time and storage required for backup processes can hinder...

How to Be the Master of Your Database Domain

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...

Why it’s Cool to be an OLTP Database Again

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.” The idea behind this new creation was that a data...

Easy Upgrade Tips for the New EDB Failover Manager

By Bobby Bissett
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...

Analyzing Postgres Adoption

By Bruce Momjian
As an open source project, the Postgres community has always had great difficulty in measuring many aspects of Postgres adoption. For example, how many people use Postgres? We don't know, because people can get Postgres from so many sources, and we have no easy way to track them. Surveys tell us...

3 Ways to Reduce IT Complexity With Digital Transformation

By Matt Cicciari
If your IT group is like most, there is never idle time when it comes to technology demands from the organization. Keeping up can be a real burden – do any of these sound familiar? -- IT needs to find new ways to keep up with the pace of development and deliver solutions faster -- Solutions need to...

Integrating Nagios with EDB Postgres Enterprise Manager

By Dave Page
A cornerstone of the Management Suite in the EDB Postgres Platform is EDB Postgres Enterprise Manager (PEM). The suite provides key management, monitoring, and development capabilities. PEM is designed for monitoring and managing both small and large fleets of PostgreSQL and EDB Postgres Advanced...

Near-Zero Downtime with New Postgres Failover Manager

By Jason Davis
A main pillar of the EDB Postgres™ Platform from EnterpriseDB™ (EDB) is the Management Suite, which provides capabilities for disaster recovery, high availability, monitoring, management, and tuning of PostgreSQL and EDB Postgres Advanced Server. EDB significantly advanced the Management Suite...