SoumitraBhandary opened a new issue, #2297:
URL: https://github.com/apache/age/issues/2297
Issue Description
While attempting to implement PostgreSQL native table partitioning on Apache
AGE vertex tables, we encountered functional limitations related to the graphid
data type. Apache AGE internally uses graphid (an AGE-specific type) for vertex
and edge identifiers. This data type introduces constraints that prevent direct
and safe use of native PostgreSQL partitioning strategies.
Specifically, attempts to partition AGE-managed vertex tables using graphid
as the partition key resulted in errors, unsupported behavior, or
non-deterministic query execution.
⸻
Environment
• PostgreSQL Version: 15.x / 16.x
• Apache AGE Version: 1.5.x (and earlier)
• Partitioning Type Attempted: RANGE / HASH
• Table Type: AGE vertex tables
(ag_catalog.<graph>_vertex_<label>)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
