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+)..
>
>