Recently I have been looking to optimize my database and its size is 7GB. I have an option to partition big table. But partitioning would just divide the big table into small ones while remaining on the same machine so same resources would be available.
Do you think partition table on same machine would bring any positive affect on performance?
My another question may have relevant information too When do hash indexes become reasonable?