> Having picked out an index scan as being the highest time user I
> concentrated on that in this case and compared the same index scan on
> MSSQL. At least MSSQL reported it as an index scan on the same index
> for the same number of rows.
I should have also pointed out that MSSQL reported that same index scan as taking 65% of the overall query time.
It was just "faster". The overall query took 103ms in MSSQL.
pgsql-performance by date
|Next:||From: Joseph Shraibman||Date: 2004-04-29 23:08:23|
|Subject: Insert only tables and vacuum performance|
|Previous:||From: Gary Doades||Date: 2004-04-29 22:31:00|
|Subject: Re: planner/optimizer question |