Hey Michael,
first of all thanks for the quick response.
Right now the production env is on a different version(10). I'm doing all my tests on a test environment. I'm familiar with the hash partitions but my queries doesnt involve the product.id therefore iti isnt relevant. All the queries uses the vendor product and thats why this column is a perfect fit as a partition column.
My main table is big (10M+) (Product), but other tables can also be big(1M+)..
