Le Lézard
Classified in: Science and technology

Breakthrough PostgreSQL 10 Delivers More Database Flexibility and Performance



BEDFORD, Mass., Oct. 5, 2017 /PRNewswire/ -- EnterpriseDB® (EDBtm), 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.

EDB Logo (PRNewsFoto/EnterpriseDB Corporation)

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

Availability
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 Postgrestm Advanced Server 10, which integrates enterprise-class performance, manageability and compatibility with Oracle® into PostgreSQL. For more information on EDB Postgres, contact sales@EDBPostgres.com.

About EnterpriseDB Corporation
EnterpriseDB® (EDBtm), 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 www.EnterpriseDB.com

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.

MEDIA CONTACTS
Cairbre Sugrue
Sugrue Communications
+44 (0)1932 429 779
Cairbre@Sugruecomms.com

SOURCE EnterpriseDB


These press releases may also interest you

at 06:30
BEIJING, Oct. 20, 2017 /PRNewswire/ -- LightInTheBox Holding Co., Ltd. (NYSE: LITB) ("LightInTheBox" or the "Company"), a global online retail company that delivers differentiated products directly to customers around the globe, today announced the...

at 06:30
MORRIS PLAINS, N.J., Oct. 20, 2017 /PRNewswire/ -- Honeywell (NYSE: HON) today announced financial results for the third quarter of 2017. "Honeywell delivered another quarter of high-quality financial results, with organic growth of five percent,...

at 06:30
SEATTLE, Oct. 20, 2017 /PRNewswire/ -- The Cloud Security Alliance (CSA), the world's leading organization dedicated to defining and raising awareness of best practices to help ensure a secure cloud computing environment, today announced an updated...

at 06:20
NEW YORK, October 20, 2017 /PRNewswire/ -- If you want a Stock Review on BBVA, BBD, DB, or ITUB then come over to http://dailystocktracker.com/register/ and sign up for your free customized report. For today, DailyStockTracker.com covers the...

at 06:03
Peeks Social Launches Brand Advertising Program TORONTO, Oct. 20, 2017 (GLOBE NEWSWIRE) -- Peeks Social Ltd. (TSX-V:PEEK) (OTCQB:PKSLF) (?Peeks Social? or the ?Company?) is pleased to announce that as part of the ongoing advancement of the...

at 06:00
VANCOUVER, Oct. 20, 2017 /PRNewswire/ - UrtheCast Corp., its subsidiary Deimos Imaging and e-GEOS (a company owned by Telespazio and the Italian Space Agency) today announced a strategic partnership to offer a unique combination of joint optical and...




News published on 5 october 2017 at 11:05 and distributed by: