Hello everyone,
We are pleased to announce the release of AgensGraph v2.12. AgensGraph is a multi-model graph database built upon PostgreSQL, one of the world’s most trusted open-source relational databases out there. The previous PostgreSQL 11, which the AgensGraph was built upon, has now been upgraded to PostgreSQL 12.
Many new relational DB features have been added due to the upgrade. Hybrid query (SQL & Cypher) performance, as well as relational data processing performance, has been significantly improved. As AgensGraph v2.12 supports up to version 12, it is now armed with more diverse and powerful features. We inform you the new version guarantees a stabilized implementation of graph features more than ever.
In the future, AgensGraph plans to go through the latest update whenever PostgreSQL 13 and 14 are stabilized. Bitnine’s multi-model graph DB will maximize the value that can be obtained from data by taking advantage of its newly improved relational characteristics.
AgensGraph v2.12 Patch Notes
1. Main Upgrade
AgensGraph’s PostgreSQL 11 has been upgraded to PostgreSQL 12.
Performance Comparison of PostgreSQL 11 & PostgreSQL 12
Data Loading Comparison (PG 11 vs PG 12) (Source: 2ndQuadrant PostgreSQL)
PostgreSQL 12 outperforms PostgreSQL 11 when loading more than 100 million data. This figure shows the speed of loading data is faster the lower time it takes.
Comparison of transactions when adding partition table (PG11 vs PG12)
(Source: 2ndQuadrant PostgreSQL)
PostgreSQL 12 has a constant number of transactions per second regardless of the number of partition tables added, whereas the transactions for PostgreSQL 11 drop as the number of partition tables increases. This figure implies higher transactions per second are better.
2. Key Performance:
– Enhanced data processing performance: supplement partitioning, increased efficiency in data retrieval
– Data import added: CSV data import filter has been added
– Development of usability improved: Provides usability of DDL statements and JSON type SQL
Below are the details of the expected effect of the above key performances.
AgensGraph 12 Key Features | Expectations |
Enhanced Data Processing Performance | Enhanced Data Retrieval |
● Able to process large amounts of data
● Collect statistical information for binding fields ● WITH clause create an efficient query plan |
● Enhanced retrieval performance due to partition pruning
● Enhanced data processing performance regardless of the number of subpartitions ● Enhanced Inlined WITH query lookup performance ● Enhanced data retrieval performance in binding fields |
Indexing and CSV Data Import | Increased Efficiency in Data Migration |
● Increased flexibility in index creation processing
● Provide extension feature for GiST index creation ● Able to use COPY FROM… WHERE clause |
● Provides real-time index regeneration feature
● Expand the target range for an index-only scan on a column ● Able to load filtered data when uploading data |
Enhanced Development Usability | Enhanced Development Usability |
● Provide storable composite/processed column type
● Create a foreign key for the subpartition table ● Provide usability in handling JSON data ● Provide a control feature for the partition table |
● Enhanced development efficiency by providing attribute types to the aggregated table
● Increased consistency in subpartition table data ● Provides usability by providing JSON data retrieval function ● A regular table can be specified or excluded as a partition table |
3. Release Testing
– We checked the normal operation of AgensGraph v2.12 and identified the improvements in accordance with the change of the base DB.
– Basic testing such as query (Cypher, SQL, Function) execution and DB management feature has been completed and operates normally.
Some packages and features are available exclusively in AgensGraph Enterprise Edition. For more information, we advise you to visit our Github or contact agens@bitnine.net.
If you have any questions, feel free to contact us.
Thank you! 😀
Download AgensGraph ! Contact us