Agensgraph Versions Save

• Merged with community PostgreSQL 12.13.
• Feature
  • Supports trigger (AGV2-52) (#583)
• Bug Fix
  • Corrects windows build failure. (#579)
  • (pg_dump) Corrects GRANT USAGE ON syntax usage on graph.
  • Allow CypherWriteClause on PL/PgSQL. (#584)
  • Includes necessary JOINs of vertices (#599)
  • Add case to PortalStrategy that AgensGraph's plan.
  • Remove cypher read clause restriction. (#601)
  • Supports VERTICES, EDGES on cypher list predicate functions. (#603)
  • Corrects AgensGraph's PortalStrategy as PORTAL_ONE_MOD_WITH.

• Merged with community PostgreSQL 13.9.
• Feature
  • Supports trigger (AGV2-52) (#583)
• Bug Fix
  • (pg_dump) Corrects GRANT USAGE ON syntax usage on graph.
  • Invalid index update in Cypher Set clause. (#602)
  • Includes necessary JOINs of vertices (#599)
  • Add case to PortalStrategy that AgensGraph's plan.
  • Corrects AgensGraph's PortalStrategy as PORTAL_ONE_MOD_WITH.
  • Supports VERTICES, EDGES on cypher list predicate functions. (#603)
  • Remove cypher read clause restriction. (#601)

• Upgrade previous AgensGraph’ DB from PG12 to PG13
  • Large databases improvements
    • Partitioning enhancements
    • B-tree deduplication
    • Incremental sort
    • Hash aggregation enhancements
    • Parallelized VACUUM for indexes
    • Extended statistics
  • Application development improvements
    • SQL/JSON: datetime()
    • FETCH FIRST .. WITH THIES
  • Administration improvements
    • Inserted data can trigger autovacuum
    • Explain WAL support
    • Drop database .. with(force)
• Feature
  • Supporting binary-upgrade for Graph Data
  • Performance improvement when running Regular Dump for Draph Data
  • Improved to return result values in each order when using head(), tail(), and last() functions targeting edge
  • Modified to use Cypher syntax in PL/PGSQL
  • Enhanced to use Cypher's CREATE/SET/DELETE syntax when creating PL/PGSQL (Experimental)
• Bug
  • Fixed the problem related to the agdata environment variable is not being recognized when running initdb
  • Setting default option to agdata when running initdb
  • Fixed an error related to the Just-in-Time (JIT) flag
  • Fixed a problem which conflicted with LLVM while using Cypher Statement
  • Fixed the problem where restore was not available when using some pg_dump functions

Full Changelog: https://github.com/bitnine-oss/agensgraph/commits/v2.5.1-rc0

Based PostgreSQL 11.11.

Full Changelog: https://github.com/bitnine-oss/agensgraph/commits/v2.12.1-rc0

Based PostgreSQL 12.11.

• Fix pg_dump & pg_restore failure ( #587 )

• Upgrade previous AgensGraph’ DB from PG11 to PG12
  • Performance of large data processing: Improved partitioning and lookup performance
  • Adding Data Import function: data import filter condition added
  • Improvement of development convenience: Provides convenience of DDL statements and JSON type SQL

• Performance Enhancement
  • Increased Robustness and Performance for Partitioning
• Usability Enhancement
  • Transactions Supported in Stored Procedures

• Bug Fix:
  • Fixed issue where dump database.

• Bug Fix:
  • Fixed issue where some queries using Variable Length Edges would not finish executing.
  • Fixed issue where some queries using Variable Length Edges would crash when the vertices do not have labels.
  • Fixed wrong MemoryContext used for RTEs.
  • Trigonometric Functions properly handle an input value of 0.
  • Fixed SET when more than 2 values are updated.
  • Update information is sent to the JDBC driver in one output value.
  • Update process can now support graph_path being set at the database level.
  • Fixed Regression Tests.