Thread: Performance MSSql vs PostgreSql

Please, see http://channel9.msdn.com/ShowPost.aspx?PostID=179064

This is one of the few performance comparisons between PostgreSQL and
MS SQL I have seen, and at first sight it seems too unfavorable to
PgSQL...  Maybe there is a bottleneck in the ODBC driver, Foxpro,
VMWare or Windows, really I don't know, I'm not an expert, but I would
not lightly believe in such results, especially for such queries that
are so simple. However, a casual reader or someone wanting to choose
between PostgreSQL and MS SQL could base his/her decision on that
results.

You may want to give the author (and readers, of course) some comments
to explain the results or to improve the benchmarks.

Regards.

On Tue, 2006-05-09 at 17:16 -0400, Ricardo Stuven wrote:
> Please, see http://channel9.msdn.com/ShowPost.aspx?PostID=179064
>
> This is one of the few performance comparisons between PostgreSQL and
> MS SQL I have seen, and at first sight it seems too unfavorable to
> PgSQL...  Maybe there is a bottleneck in the ODBC driver, Foxpro,
> VMWare or Windows, really I don't know, I'm not an expert, but I would
> not lightly believe in such results, especially for such queries that
> are so simple. However, a casual reader or someone wanting to choose
> between PostgreSQL and MS SQL could base his/her decision on that
> results.

All the queries tested are "Select *" issued with a single Exec, no
Fetch-es at all.

It's all down to how many rows are cached by the basic Exec call, in
anticipation of later Fetch-es.

You can always find a trick that one or other does better.

--
  Simon Riggs
  EnterpriseDB          http://www.enterprisedb.com