Monday, November 06, 2017

SQL Database, Table, and Data Partitioning: When and How to Do It

DZone Database Zone
SQL Database, Table, and Data Partitioning: When and How to Do It
SQL Database, Table, and Data Partitioning: When and How to Do It

When I first came across table partitioning and started searching, I realized two things. First, it is a complex operation that requires good planning. Second, in some cases, it can be proven extremely beneficial, while in others, it can be a complete headache.

So the first question is when investing time in table partitioning seems a good way to go.  The typical case when you consider applying partitioning is the following:

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...