From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Ricardo Stuven <rstuven(at)gmail(dot)com> |
Cc: | pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: Performance MSSql vs PostgreSql |
Date: | 2006-05-10 06:58:37 |
Message-ID: | 1147244317.4572.80.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2006-05-10 12:01:13 | Re: Banners on postgresql.org not running on pgsql? |
Previous Message | Matteo Beccati | 2006-05-10 06:55:52 | Re: Banners on postgresql.org not running on pgsql? |