Open dhiaayachi opened 2 weeks ago
Thank you for your feature request! It's great to hear about your interest in using table partitioning with Temporal.
While Temporal doesn't currently directly support table partitioning, you can explore other ways to achieve similar performance benefits. Here are a few suggestions:
shard_id
: You can leverage Temporal's shard_id
in your SQL queries to distribute queries across different shards. This can improve query performance and scalability, especially with large datasets. Please let us know if you have any further questions. We are always happy to help!
Thank you for the feature request!
While Temporal doesn't currently offer direct integration with PostgreSQL table partitioning, you can achieve similar results through:
shard_id
in your SQL queries to filter data. We value your input and will consider your suggestion for future improvements.
Is your feature request related to a problem? Please describe. No.
Describe the solution you'd like Most temporal sql query use shard_id as condition, for postgres database partition by hash is nice for large table. Maybe some table partition number could be number of shards.
Describe alternatives you've considered No.
Additional context https://www.postgresql.org/docs/current/ddl-partitioning.html