There is using autovacuum to keep old rows from accumulating and reducing performance. Then there's being strategic about using autovacuum to ensure this nifty Postgres feature keeps you running at maximum power. Bruce Momjian explains in Controlling Autovacuum ... http://bit.ly/2jvZBHS
Learn how to apply partition pruning in EDB Postgres, complete with the code examples for exploring the two types of pruning that Postgres supports, constraint exclusion pruning and fast pruning. http://bit.ly/2i4WBRa
Empower your project teams with the performance, flexibility, speed, and tools they need to develop new digital applications quickly and efficiently by choosing a database, and database vendor, that scores 90 points or more on this special assessment. Read the blog: 5 Step Assessment: Selecting a DBMS for New Application Development http://bit.ly/2eO4YP5
Learn how to install and set up EDB Postgres Failover Manager from the expert at EnterpriseDB, Bobby Bisset, who has recorded a new video now available on the EnterpriseDB YouTube channel. EDB Postgres Failover Manager provides high availability, to help keep the enterprise’s critical data infrastructure running well with virtually no downtime, and ensure the database infrastructure’s ability to keep running in the event of failure. Watch: EDB Postgres™ Failover Manager 2.1 Installation and Setup - http://bit.ly/2g3NyiM
What to do with the old master when you've promoted a standby database to become the new master? pg_rewind is a nifty tool for mastering the intricacies and PostgreSQL 9.6 has a new feature that unwinds the timelines to ensure data is synched. Read on, code samples included. http://bit.ly/2idGDWj
The pg_rewind tool was first introduced in PostgreSQL 9.5. This is best used in a situation when a standby becomes a master, then the old master can be reattached to the new master as a standby without restoring it from the new base backup.
See a live demo of the new EDB Ark Database-as-a-Service (DBaaS) and learn how to use EDB Ark to automate your database deployments to instantly spin up new databases. EDB Ark lets you manage your database environment easier using the same GUI for all clouds. It's the only product that gives you public cloud manageability for your private or hybrid clouds. Register now for the January 26 webinar - 8 am ET (http://bit.ly/2ia7rBX) or 1pm ET (http://bit.ly/2ixbLfl)
Learn how a major U.S. wireless carrier migrated a 100TB Oracle database to a cool new EDB Postgres-Cloudera configuration - in two weeks - to gain greater agility and data analytics. http://bit.ly/2ihJKvm
Competitive pressures have brought profound change to the telecommunications industry. Telecom companies have seen a rise in new digital devices and changing business models for delivering services, while traditional voice and messaging products have become commoditized, pushing prices downward.
When the Daiwa Institute of Research Business Innovation wanted to expand its Energy Management System application to offer services to a broader range of customers, the organization turned to EDB Postgres. Find out why. http://bit.ly/2hTd5IH
The combined use of various database and data store technologies provides a holistic view of data across existing databases, or when a particular functionality of a NoSQL database is required. Learn how EDB helps achieve this on-premises, and in the cloud. http://bit.ly/2iEPrUO
The contributions to Postgres from EnterpriseDB and across the open source community, on display at the recent PGConf.EU, demonstrated how collaboration helps make Postgres better for everyone. http://bit.ly/2fXvG9n
() 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.