Joel Fradkin wrote:
> I also tried a simple select * from tblcase where clientum = 'SAKS'
>
> On both MSSQL and Postgres.
>
> MSSQL was 3 secs, Postgres was 27 secs.
>
>
>
> There is a key for clientnum, but it appeared on both systems
> (identical Dell Desktops Postgres is running Linux MSSQL is XP) it did
> not do a indexed search.
>
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'll want to run vacuum analyze.
Dennis Sacks
dennis(at)illusions(dot)com