lvorySQL 2025生态大会暨PostgreSQL高峰论坛：从表到树 - PostgreSQL 中不断扩展的图生态系统

FromTablestoTrees:The

ExpandingGraph

Ecosystem

in

PostgreSQLUmar

HayatSKAIWorldwide28-06-2025HOW2025PostgreSQL&

IvorySQL

Eco

ConferenceIam

Umar

Hayat-Software

Engineer-WorkatSKAIWorldwide(Bitnine)-

Interest:-

PostgreSQL-

AgensGraph-

PgPool-II-

From

Pakistan,

Lives

InSouth

KoreaHOW2025PostgreSQL&

IvorySQL

Eco

Conference0

4SQL/PGQand

ISO/GQL06Future

DirectionsAbout

This

Talk?05GraphsandAI0

2AgensGraph0

3ApacheAGE0

1IntroductionHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceHOW2025PostgreSQL&

IvorySQL

Eco

ConferencePastFirst

Movers–AgensGraph●First

Release

:

2017

by

Bitnine●Early

proofofPostgreSQL’s

potentialforgraphs●A

PostgreSQLfork

purpose-builtforgraphworkloads●Graphsarefirst-class

citizensSource:

/product/dbms/agens_graphHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceAgensGraph:

Example●Cypherquery

support●Multi-model:coexistenceofrelational

and

graph

data●HybridQuery:

relational(SQL)+

graph

(Cypher

support)CREATEGRAPH

PeopleCREATEVLABEL

Person;CREATE

ELABEL

Knows;MATCH(a:Person{

name='Umar'})-

[

:Knows]

-

(b:Person)RETURNAS

n,a.nameAS

b;HOW2025PostgreSQL&

IvorySQL

Eco

Conference●Inspired

byAgensGraph●ApacheAGE=“A

Graph

Extension”●Open-source,

underApache

Incubator2019●Apachetop

level

in2022●Seamless

integrationwithexistingSQLworkflows●Cyphercompatibility●Combines

relational

power+graphqueriesSource:

https://news.apach/foundation/entry/asf-project-spotlight-apache-

ageHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceApacheAGEAGE–

ExampleSELECTcreate_graph('People')CREATEcreate_vlabel('People',‘Person’);CREATEcreate_Elabel('People',‘Knows’);SELECT*FROMcypher('graph_name',$$MATCH(n:Person)-[r:KNOWS]->(m:Person)WHERE

n.name='Umar'RETURN

m$$)AS

(m

agtype);HOW2025PostgreSQL&

IvorySQL

Eco

ConferenceHOW2025PostgreSQL&

IvorySQL

Eco

ConferencePresentSource:

/news-releases/new-query-language-for-graph-databases-to-become-international-standard-300919138.htmlGraphStandardsHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceGraphStandardsSQL/PGQ:

PropertyGraphQuerying

inSQL●Led

by

ISO/ANSISQL

committee●Purpose:

PropertyGraph

Querying

inSQLISO/GQL:

InternationalstandardforGraphQuery

Language●Collaborationamongvendors,researchers,community●Purpose:

languagesimilarto

CypherHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceSQL

SQL/PGQ

GQL●Purpose:

PropertyGraph

Querying

in

SQL●Leverageexisting

SQL

knowledge●Combine

relational+

graph

data

in

one

querySource:

https://ww/standard/79473.htmlSQL/PGQ–OverviewHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceCREATE

PROPERTYGRAPH

PeopleVERTEXTABLES

(Person

LABEL

node

PROPERTIES(

id,

name,

properties)

)EDGETABLES

(KnowsSOURCE

KEY(from_id)

REFERENCES

nodes

(

id)

DESTINATION

KEY(to_id)

REFERENCES

nodes

(

id)

LABEL

relationship

PROPERTIES(properties));CREATETABLE

Person(

idSERIAL

PRIMARY

KEY,nameTEXT,

propertiesJSONB);CREATETABLE

Knows(

idSERIAL

PRIMARY

KEY,from_id

INTEGER

REFERENCES

nodes(id),

to_id

INTEGER

REFERENCES

nodes(id),propertiesJSONB);SELECT

nameFROMGRAPH_TABLE

(PeopleMATCH(a

IS

PersonWHERE='Umar')<-[e

IS

Knows]-(b

IS

Person)

COLUMNS(AS

name));KeyConcepts

inSQL/PGQHOW2025PostgreSQL&

IvorySQL

Eco

Conference●InternationalstandardforGraph

Query

Language●Collaborationamongvendors,

researchers,community●Aimstodefinecore

languagesimilar

to

CypherSource:

https://ww/standard/79473.htmlHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceISO/GQLKeyConcepts

in

ISO/GQLCREATEGRAPHTYPE

PeopleTYPEPerson(nameString)Knows(since

DATE)CREATEGRAPH

PeopleOF

PeopleTYPE;FROM

PeopleMATCH(a:PersonWHERE='Umar')<-[k:Knows]-(b:Person)

RETURN

AS

nameHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceFutureRelevancetoAI●KnowledgeGraphs,

Reasoning

&

Context●AI

benefitsfromdeeplyconnecteddata●

GraphRAG●CombineVector+

Graph

IndexHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceWhat’sComing

Next●Nativegraph

support

in

PostgreSQL●CompliancewithSQL/PGQ&

ISO/GQL●Enhancedquery

planningforgraph

queries●Performancetuningforgraph

queries●Indexingfor

hybrid

models●Toolingmaturityand

adoptionHOW2025PostgreSQL&

IvorySQL

Eco

ConferenceSummary●Multiple

projectandconti