pg_partman 3.0.0 - real-world usage of native partitioning and a casefor native default
От | Keith Fiske |
---|---|
Тема | pg_partman 3.0.0 - real-world usage of native partitioning and a casefor native default |
Дата | |
Msg-id | CAG1_KcA2pxO5+Fviwb-4nrdF+FXuqV9YkKyE+oH3FGGMjyZktA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pg_partman 3.0.0 - real-world usage of nativepartitioning and a case for native default
|
Список | pgsql-hackers |
I've gotten pg_partman working with native partitioning already so I can hopefully have things ready to work when 10 is released. I've got a branch on github with this version for anyone to test and I'll hopefully have this released in the next few weeks after I finish some more testing myself. Any feedback would be appreciated!
https://github.com/keithf4/pg_partman/tree/v3.0.0
Thankfully since native partitioning still uses inheritance internally for the most part, pg_partman works pretty well without nearly as much change as I thought I would need. The biggest deficiency I'm seeing has to do with not having a "default" partition to put data that doesn't match any children. The fact that it throws an error is a concern, but it's not where I see the main problem. Where this really comes into play is when someone wants to make an existing table into a partitioned table. There's really no easy way to do this outside of making a completely brand new partition set and copying/moving the data from the old to the new. Yes there are technically ways to do this fairly seamlessly to the user of the partitioned table, but the complexity of those methods seems absurd in the face of just allowing a default partition. https://github.com/keithf4/pg_partman/tree/v3.0.0
В списке pgsql-hackers по дате отправления: