Postgres schema support partition table feature

[zedongh]

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

[jeacott1]

I'd prefer to see multi-db/schema sharding support instead of in-db table sharding. Cadence appears to be capable of this, why not temporal?