Timeline for Modifying a non managed table partition
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 7, 2015 at 21:40 | comment | added | Thomas Kejser | @DanGuzman: That is slower, because you cannot do the INSERT...SELECT concurrently anymore | |
| Feb 7, 2015 at 15:48 | comment | added | Dan Guzman | I suggest this same basic technique but using a single staging table partitioned using the new version of the partition function and scheme. That avoids the need for multiple identical tables the check constraint. | |
| Feb 6, 2015 at 14:52 | history | answered | Thomas Kejser | CC BY-SA 3.0 |