Efficient Partitioning of Large Tables in PostgreSQL and SQL Server using the First Letter

While working with one of my ISV’s customers, I was challenged by the need to partition an XXL table according to the 1st letter of a string with variable length (5-20).

The need comes from the fact that most of the queries were direct referring to this string and partition elimination is crucial to archive excellent performance and eliminate unneeded data reads.

The challenge was to support the demand of the variable length partitioning in a simple way.

Please enjoy my blog Efficient Partitioning of Large Tables in PostgreSQL and SQL Server using the First Letter - Microsoft Community Hub which includes code sample for both PostgreSQL and Azure SQL database.

#postgresql #sqlserver #azure #databases #partitioning