Add support for tablespaces

Open dantownsend opened this issue 3 years ago • 0 comments

Discussed in https://github.com/piccolo-orm/piccolo/discussions/525

^{Originally posted by theelderbeever May 24, 2022} Background on the question... some of our tables are very large and our deployment infrastructure limits us to 16TB of disk space per provisioned drive. Having all of the tables on the same drive runs the risk of filling up our drive. We would like to set tables to tablespaces so we can provision drives on a per table/tablespace basis.

Is there a way to CREATE TABLE foo(i int) TABLESPACE space1; when generating the ORM Models?

Is the solution to generate empty tables using a raw SQL migration and then add the models in the next migration? Would Piccolo perform the correct ALTER TABLE commands if the tables weren't generated via the ORM models?

May 24 '22 16:05 dantownsend