Confirmed users, Bureaucrats and Sysops emeriti
2,088
edits
Places:FsyncApproach: Difference between revisions
→Partitioning Approach
No edit summary |
|||
| Line 13: | Line 13: | ||
Cons: | Cons: | ||
Tasks: | |||
* determine which table(s) need to be partitioned | |||
* initialize temp table(s) | |||
* modify all queries that interact w/ the partitioned table(s) | |||
* periodic flush of temp to permanent table (ensuring pk sync) | |||
=Long Open Transaction Approach= | =Long Open Transaction Approach= | ||