Re: same question little different test MSSQL vrs Postgres

Joel Fradkin wrote: <blockquote cite="mid000901c5035a$3b619cc0$797ba8c0@jfradkin" type="cite"><style>
<!--/* Style Definitions */p.MsoNormal, li.MsoNormal,
div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"TimesNew Roman";}
 
a:link, span.MsoHyperlink{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{color:purple;text-decoration:underline;}
span.EmailStyle17{font-family:Arial;color:windowtext;}
@page Section1{size:8.5in 11.0in;margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1{page:Section1;}
--> </style><div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt;
font-family:Arial;">I also tried a simple select * from tblcase where clientum = ‘SAKS’</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">On both MSSQL and
Postgres.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family:
Arial;">MSSQLwas 3 secs, Postgres was 27 secs.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10pt; font-family: Arial;"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10pt; font-family: Arial;">There is a key for clientnum, but it appeared on both systems (identical
DellDesktops Postgres is running Linux MSSQL is XP) it did not do a indexed search.</span></font></div></blockquote><br
/>One of the things you'll want to do regularly is run a "vacuum analyze". You can read up on this in the postgresql
docs.This is essential to the indexes being used properly. At a bare minimum, after you import a large amount of data,
you'llwant to run vacuum analyze.<br /><br /> Dennis Sacks<br /><a class="moz-txt-link-abbreviated"
href="mailto:dennis@illusions.com">dennis@illusions.com</a><br/>