"EDBs contributions to Postgres community during the development cycle have a strong focus on performance and scalability. PostgreSQL 9.5 provides significant improvements in scalability, which will benefit our large corporate and government customers, as they pass through high-core-count servers, which a large number of concurrent users, and mission-critical applications support, "commented Marc Linster, Ph.D., Senior Vice President of Products and Services at EnterpriseDB.
Benchmark Test Results
Show EDBs benchmark tests that PostgreSQL 9.5 features significant performance improvements for workloads that are running a large extent the same. For example, showed 64 concurrent connections on a 24-core / 496 GB of RAM system an improvement of 96 percent compared with PostgreSQL 9.4.
EDBs customers and PostgreSQL users, particularly those with a workload that supports a large number of concurrent users can be expected through a variety of PostgreSQL 9.5 applications measurable benefits:
- increased database performance volume and improved scalability,
- increased performance with existing infrastructure,
- effective decision-making by developing decision support system (DSS) for analysis and
- faster response times and significant improvements in customer service.
Performance and Scalability
The performance and skalierbarkeitsbezogenen advantages in PostgreSQL 9.5 include:
- Simultaneity of Shared Buffer: PostgreSQL 9.5 can support a larger volume of data, thereby increasing as a result of higher optimization of the locking system in shared buffers performance.
- Advanced simultaneous locks: A reduced number of page locks and pins that hold indices during scans, PostgreSQL can support 9.5 in system with high transactional performance more concurrent users, which also increases performance.
- Buffer mapping: Thanks to an improved shared buffer management PostgreSQL 9.5 can support a larger number of shared buffer partitions.
- Prefix Sorting: According to benchmark tests may PostgreSQL 9.5 large text and number fields by means of a shortened sorting optimization 20 percent to 30 percent faster than sort PostgreSQL 9.4.
Horizontal scalability and integration
Foreign Data Wrappers (FDWs) create away the basis for accessing data across multiple servers, which will form the basis for future developments in the area of horizontal sharding. A new feature in PostgreSQL 9.5 FDW - FOREIGN IMPORT SCHEMA - automates importing schemas from external databases, which are connected by FDWs with PostgreSQL. This reduces the potential for errors and replaces a manual process when it is accessed from external sources for data.
By FDWs PostgreSQL can read data from other databases and write, and access them as PostgreSQL tables where developers with SQL can perform a query as if it were a native PostgreSQL. Be cited these developments by EDB and Japan's Nippon Telegraph and Telephone (NTT).
Productivity and safety
9.5 Some of the major advances in PostgreSQL terms of productivity and security, and acceleration of data analysis:
- A new Indexierungsart called BRIN (block RangeIndex) that provides very small indexes the metadata (eg minimum and maximum values) used to describe a range of information to improve the performance of queries. Thus, queries for tables that store data sequentially (ie in numerical order or according to data / time fields), skip the bulk of the table, when searching for data within a certain range.
- A trio of new analysis capabilities (GROUPING SETS / CUBE / ROLLUP) summarizes quickly transfer large quantities of data on different dimensions along time. These are typically used in data warehousing environments where companies need to summarize information like number of employees across departments, locations and remit of time or the e-commerce order history through various dimensions of demographic and geographical information across. This provides higher performance for complex queries and enables companies to produce better tailored to your results.
- UPSERT is one of the functions has been desired as an extension of Postgres most common. Syntactically database developers, the new "ON CONFLICT DO NOTHING" (or "ON CONFLICT DO UPDATE") effective and efficient way to insert data, while at the same potential conflicts with respect to the insertion without writing custom code to be handled.
- Increasing improvements to the document data type JSONB also manage the ability of Postgres, unstructured and semi-structured data. New operators and functions simplify the ability of developers to compare individual elements of the document in the database and update.
- By row-level security (Row Level Security), DBAs can implement policies to limit what can be viewed or updated, depending on any number of properties such as user name, release level or organizational membership. During Row Level Security is new to the open source community Postgres, Postgres Advanced Server EDB has built Row Level Security for more spending - an option that is used by EDBs Postgres corporate customers for several years. The version of this function of EDB Postgres Advanced Server is syntactically compatible with the implementation of Oracle and encloses policy enforcement at the column level (limiting the visibility of sensitive values or columns) and provides a more stringent policy enforcement (rather AND use instead of OR to more apply policies).
PostgreSQL 9.5 is generally available. To download the free version of PostgreSQL using a simple one-click installer to, click here or visit the download page of the PostgreSQL community. In order to use the full value of PostgreSQL for use in companies, the database is also available as part of the EDB Postgres Standard subscriptions are available, what the PostgreSQL 9.5 database plus immigration, integration and management tools for developers and DBAs, as well as global round- the-clock support including with. In addition, a wide range of training, professional services and certification solutions from EDB and EDB partners available.
To find out more about PostgreSQL 9.5, please send an email to email@example.com and / or download the Webcast Overview of PostgreSQL 9.5 (Overview of PostgreSQL 9.5) down, the Bruce Momjian, co-founder of the PostgreSQL Global Development Group and EDB Senior Database Architect, was recorded.
Connect yourself with EnterpriseDB
Follow us on Twitter: https://twitter.com/enterprisedb_DE
More information, visit www.enterprisedb.com available and on the EnterpriseDB blog at https://blogs.enterprisedb.com. Additionally, you can EnterpriseDB also on Twitter, Facebook, Google+ or LinkedIn follow.