How to get fast result from a SQL query
I have a Postgre SQL database table which contains over 5 million entries.
Also have a CSV file which contains 100,000 entries.
I need to run a query to get data from DB which related to the CSV file's
data.
However as per the everyone's understanding and with my own experience,
This kind of query takes ages to get completed. (more than 6 hours, as per
my guess)
So as per the newest findings and tools, do we have a better, fast
solution to perform this same task?