Re: Subpartitioned by LIST

[Mattias Jonsson]

You can only do subpartitioning with [LINEAR] HASH or KEY. (And only on RANGE/LIST partitioning).

I would give HASH or KEY subpartitioning a try, just to see if it improves your situation.

Please remember that increasing the number of total partitions will also add overhead for each query, so you may gain performance on larger queries, but loose performance on smaller queries, like simple selects on PK.