CONTACT
GitHub
YouTube
LinkedIn
Facebook
Medium
  • PRODUCTS
    • AgensSQL
      • Standard Edition
      • Enterprise Edition
      • Enterprise Edition Plus
      • Management Tools
    • AgensGraph
    • Visualization & Analytics
  • USE CASES
  • SERVICES
  • RESOURCES
    • Documentation
    • Learn
  • BLOG
  • COMPANY
    • About Us
    • Contact
  • IR
    • IR 공고
    • IR 공시 정보
    • IR 재무 정보
  • Download

AgensGraph v2.12 Released!

2022. 05. 05AgensGraph, Graph Databaseadmin

AgensGraph v2.12

 

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

 

PostgreSQL Comparison

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.

 

PostgreSQL Comparison

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

 

Related

Tags: AgensGraph, AgensGraph 2.12, Bitnine, Cypher, GDB, Graph Database, Graph DB, PostgreSQL, RDB, Relational DB, Relational-Database, SQL
Previous post Understanding Master Data Management (MDM) with Graph Modeling Next post Why Explainable AI requires Graph Database

Related Articles

The World’s Graph Database MEETUP Status & Ranking

2016. 06. 13admin

4 reasons for rising use of graph databases

2017. 01. 19admin

AgensGraph 2.1 is Available on AWS NOW !!

2019. 03. 03admin

Leave a Reply Cancel reply

Your email address will not be published.

PRODUCTS USE CASES SERVICES RESOURCES BLOG COMPANY
AgensSQL Documentation About Us
AgensGraph Learn Contact
Graph-based Solution
2023 by Bitnine Global Inc. All Rights Reserved.
CONTACT
Bitnine Data Summit 2023 “엔터프라이즈를 위한 성공적인 클라우드 전환”에 지금 등록하세요!