search

bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.33k stars 148 forks source link

Does Agensgraph support the way you configure partitioned tables to improve performance? #326

Open wenxue202012 opened 6 years ago

wenxue202012 commented 6 years ago

@gtyun Does Agensgraph support the way you configure partitioned tables to improve performance? In other words, is there any other plan for 'Graph Partitioning'?

gtyun commented 6 years ago

Postgresql 10 supports partitioned table through table inheritance. But Agensgraph does not support it now and for a time. If Agensgraph is merged with postgresql 10, partitioning graph has other many problems.

wenxue202012 commented 6 years ago

I'm very glad to hear that. But the graph is getting bigger and bigger, and it doesn't partitioning graph. It's only on the partition table that the performance limit of the single machine is a problem.