I have a 16 core , 12 GB ram, a SSD 500 MB/s I have 1 millions rows in my "Pages" table
The pages contains 1 unique key that are HostID ( int ) and Page( varchar )
I use partitioning by key and have created briefly about 100 partitions
But i'm not sure that how many partitions that i should create for best performance.
briefly about 70 GB of data I use primary key to search :
select * from table where HostID = 1 AND Page = 'asdasd'