[SQL] MSSQL versus Postgres timing

[Joel Fradkin]

All is moving along well. I have all my views and data and am testing things out a bit. A table with 645,000 records for associates has view (basically select * from tblassociates where clientnum = ‘test’) This is taking 13 seconds in postgres and 3 seconds in MSSQL.   I tried making an index on clientnum (there is one on clinetnum, associateID in MSSQL). I did an analyze. I did a set seq scan off   Is there a possibility postgres is this much slower, or (my hope) I am missing some key concept. Be glad to provide the view and tables etc.   Joel Fradkin