I have a dedicate server 32GB Ram, 12 Core CPU, 15000rpm HDD (raid 1)
i imported some data ( about 110 GB ) into the table to the postgres, and i created partition Data on my table by date ( day by day )
i have a lot of condition and inner join's in my query such as LIKE . so when i run query, it takes more than 10 min. however it just 10% of ram is and just 50% of hdd is and one core of cpu ( not 100% ) has been used. how can i extend usage of our resource?
is apache spark useful here?
database has been config my postgres by PGTune.