As you can see I'm a newbie and been flailing for 2 weeks.
I am doing a simple query such as:
"select * from all_visits where reason_for_visit in ('CE233','4E233','GH399')
This query in Postgres takes 2 hours, and I give up as I don't have time to wait (I'm doing some case control studies and doing some exploratory basic research).
This exact same query in SQL server 2014 takes about 30 minutes or less. I've tried these queries on the same machine and Postgres is faster (8gb ram, i5 processor).
I would much rather use Postgresql, over SQLServer, but not if the performance hit is this bad.
What am I doing wrong? I have no reason to believe that SQL Server is more 'ready to go' out of the box than Postgres, or is it?
I have increased the memory buffer to 4gb and the effective cache to 6gb but that's all I know how to do. Would appreciate some help as well as insight.