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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.