Skip to content

Postgres partitioning enhancements: sub-partitioning + tablespace on partitioned parents #21

@ihistand

Description

@ihistand

Remaining native-partitioning gaps (cli/api/dbadapters/postgres_execution_sql.ts createPartitionedTableTasks):

  • Sub-partitioning (nested PARTITION BY) — not supported.
  • Tablespace on the partitioned parentcreatePartitionedTableTasks omits it (the regular createTable applies it). Minor.

Not gaps (confirmed): indexes + opclass on partitioned tables already work (createIndexes runs for the partitioned path). fillfactor on a partitioned parent is invalid — Postgres forbids storage params on partitioned tables. Split from #15.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions