Re: Performance MSSql vs PostgreSql
От | Simon Riggs |
---|---|
Тема | Re: Performance MSSql vs PostgreSql |
Дата | |
Msg-id | 1147244317.4572.80.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Performance MSSql vs PostgreSql ("Ricardo Stuven" <rstuven@gmail.com>) |
Список | 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
В списке pgsql-advocacy по дате отправления: