Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

postgres: Support creating partitioned tables #722

Open
gitmalong opened this issue Dec 1, 2023 · 0 comments
Open

postgres: Support creating partitioned tables #722

gitmalong opened this issue Dec 1, 2023 · 0 comments

Comments

@gitmalong
Copy link

I'd love to see SeaQuery support creating partitioned Postgres tables.

Motivation

Partitioned Postgres tables help to scale Postgres / can drastically improve performance on large data sets.

Proposed Solutions

For a full blown partition support there are some more expressions that need to be supported but I think the support for creating tables with PARTITION BY RANGE is already a good starting point. Hence this issue is just about that.

CREATE TABLE measurement (
    city_id         int not null,
    logdate         date not null,
) PARTITION BY RANGE (logdate);

Additional Information

This issue blocks SeaQL/sea-orm#1962

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant