WebsiteGear Logo Log In
New User? Sign Up
About | Contact | FAQ
  Home News Web Hosting Computer Hardware Friday, December 15, 2017 
Add Press Release News | News Feeds Feeds | Email This News Email

Breakthrough PostgreSQL 10 Delivers More Database Flexibility and Performance
Thursday, October 05, 2017

BEDFORD, Mass., Oct. 5, 2017 /PRNewswire/ -- EnterpriseDB(® )(EDB(TM)), the database platform company for digital business, today applauds the achievement of the PostgreSQL Global Development Group for its newly released PostgreSQL 10. Administrators now have more flexibility as well as powerful new database features, including new parallel query and replication capabilities and performance improvements.

"Complex digital applications and analytic architectures require a more powerful and flexible database. As a major contributor to the Postgres core code base, EDB devoted countless developer hours to ensuring PostgreSQL 10 achieved new levels of performance and deployment flexibility," said Marc Linster, Ph.D., Senior Vice President, Product Development, EnterpriseDB. "PostgreSQL 10 delivers features EDB customers require to build modern applications in the agile frameworks that many have adopted to remain competitive."

PostgreSQL 10, the most significant release in recent years, gives DBAs an array of new deployment choices. DBAs now have more flexibility when configuring PostgreSQL to meet the specific demands of their workloads and infrastructure. The new release of PostgreSQL also adds powerful new performance advances that return query results faster.

In addition to making major contributions to the open source PostgreSQL project, EDB is also a PostgreSQL packager and makes the database available to customers as part of the EDB Postgres(TM) Standard Edition. Customers making this selection use open source PostgreSQL but also get an integrated set of supported tools, developed by EDB using best-in-class technology, a powerful DBaaS management console, as well as a full menu of training and professional services offerings. Customers also get full access to the deep capabilities and resources of a Gartner recognized, enterprise-class vendor.

The new features in PostgreSQL that expand deployment options in PostgreSQL 10 include:

Logical Replication: With logical replication, DBAs have the ability to control replication by table or by database, in cases selectively replicating individual items and aggregating data spread across multiple servers for queries. This feature can also be used to easily create standbys for near-zero downtime upgrades.

Declarative Partitioning: This feature replaces and automates troublesome manual tasks that involved maintaining and updating triggers and rules for creating and managing table partitions. Bulk loading performance is also greatly improved compared to older, trigger-based solutions. Developers benefit as well. With partition controls now part of the database schema, they no longer must be written into the application.

Multi-column Statistics: DBAs can now specify additional statistics that should be gathered to improve query performance when what would otherwise be gathered by default would not have been sufficient to support creation of a high-quality query plan. Instead of using complex and fragile workarounds for poorly performing queries, DBAs can implement a robust fix with a single command.

ICU Collation Support: Previous releases of PostgreSQL automatically imported collations available from the host operating system. Now, PostgreSQL 10 adds the ability to use collations from the popular ICU library, allowing extensive customization of sorting behavior and cross-platform stability.

SCRAM Authentication: PostgreSQL 10 institutes enhanced security by implementing a Salted Challenge Response Authentication Mechanism (SCRAM) protocol for managing passwords. With SCRAM-SHA-256 in PostgreSQL 10, neither the information stored on the server nor what is exchanged during authentication is sufficient for unauthorized access.

The new features in PostgreSQL 10 that increase database performance include:

Improved Query Parallelism: Basic parallel query was introduced in PostgreSQL 9.6, giving way to expanded capabilities for implementation of greater functionality for real world use cases. The first of these new capabilities have come with PostgreSQL 10. New features include additional scans that control how the database executes and sorts parallel queries, and mechanisms for how it combines data to produce results. Parallel query has produced 2-4x performance increases for some workloads.

Expression Evaluation Engine: When running queries against large data sets, this enhancement now enables dramatically improved performance. This optimization applies modern programming techniques tailored to the latest generation of CPU hardware to expression evaluation.

Quorum Commit: This feature provides greater flexibility and performance for DBAs who require multiple synchronous replication standbys. With PostgreSQL, DBAs can specify different wait policies when designating standby servers to accept data for replication. Demand for synchronous replication across multiple databases and data centers has been growing. Greater flexibility will make it easier for companies to deploy PostgreSQL where synchronous replication is required. Financial services, for example, need to maintain consistent customer records across multiple data centers and geographies.

PostgreSQL 10 is available immediately. To download the free version of PostgreSQL using an easy one-click installer, click here to download, or visit the PostgreSQL community download page here. To leverage the full value of PostgreSQL for enterprise deployments, the database also is available as part of the EDB Postgres Standard subscription. All features of PostgreSQL 10 will be included in the upcoming release of EDB Postgres(TM) Advanced Server 10, which integrates enterprise-class performance, manageability and compatibility with Oracle(®) into PostgreSQL. For more information on EDB Postgres, contact

About EnterpriseDB Corporation
EnterpriseDB® (EDB(TM)), the database platform company for digital business, delivers the premier open source-based data platform for new applications, cloud re-platforming, application modernization, and legacy migration. EnterpriseDB integrates with enterprise technologies and infrastructures for hybrid cloud management, data integration, and data warehousing. Our customers benefit from the highest performing, most reliable, flexible, open, and cost-effective data management platform available. EnterpriseDB is based in Bedford, Massachusetts. For more information, visit

EnterpriseDB is a registered trademark of EnterpriseDB Corporation. EDB and EDB Postgres are trademarks of EnterpriseDB Corporation. Other trademarks may be trademarks of their respective owners.

Cairbre Sugrue
Sugrue Communications
+44 (0)1932 429 779

View original content with multimedia:

SOURCE EnterpriseDB

Email This News Email | Submit To Slashdot Slashdot | Submit To Digg | Submit To | News Feeds Feeds

Nav Changes in End-user Preferences will Help the Jan-san Cleaning Market Reach $5 Billion by 2022, Sees Kline | Dec 15, 2017
Nav Deezer Launches Proprietary Audio Recognition Feature | Dec 15, 2017
Nav Truck Drivers Honored with Holiday Dinner and Free Concert from Country Music Association (CMA) "Vocal Duo of the Year" Brothers Osborne | Dec 15, 2017
Nav AIC Announces Its New Line of Servers With Intel® Xeon® Scalable Processors | Dec 15, 2017
Nav Global RNA Sequencing Market 2016 to 2022: Market to Grow at a CAGR of 12.07% to Reach $3.6 Billion, from $1.86 Billion in 2016 | Dec 15, 2017
Nav Global Semiconductor Wafer Polishing and Grinding Equipment Market Research Report 2017-2021 | Dec 15, 2017
Nav eSpeakers and karmaSpeaker Partner to Create First Event Management CRM Built for Professional Speakers | Dec 15, 2017
Nav Global $40.6 Billion Smart Highway Market Forecasts to 2022 | Dec 15, 2017
Nav MDA advances innovative robotics and rovers for space exploration and to support on-going operations of the ISS | Dec 15, 2017
Nav The LED Revolution 2017: Analyze the LED Backlight market for Notebook PCs, LCD TVs, Desktop Monitors, Large Others, and Small/Medium LEDs | Dec 15, 2017

Submit News | View More News View More News