Обсуждение: [Fwd: Question]

Поиск
Список
Период
Сортировка

[Fwd: Question]

От
Justin Clift
Дата:
Hi guys,

Does anyone have the inclination to talk to these guys?

:-)

Regards and best wishes,

Justin Clift


-------- Original Message --------
Subject: Question
Date: Wed, 23 Apr 2003 13:49:21 -0400
From: CGSI Inc. - GCIS Inc. <info@cgsi.ca>
Reply-To: <info@cgsi.ca>
Organization: Le Centre General des Services Internet Inc.
To: <justin@postgresql.org>
CC: <info@gcis.ca>



**
**
**
*Hello.  We are considering using Postgre SQL over SQL server.  We need
the trigger*
*capability.  However, I am told by a few programmers that Postgre
operated slower*
*than say SQL server or other database solutions in the same category.*
**
*First, is there any thruth to this?   If it is so, how could you
explain that?   What are*
*the remedies?*
* *
*
(We are assuming that all platforms run on all the same servers, hence
have access*
*to all the same amount of memory and processing power).*
*** *
*Thank you for your answer*
*** *
*Serge Thibodeau,*
*GCIS Inc.*
*sthibodeau@gcis.ca <mailto:sthibodeau@gcis.ca>*
*** *
*** *
*_________________________________________*


Re: [Fwd: Question]

От
Josh Berkus
Дата:
Mr. Thibodeau,

> **
> *Hello.

Hello.  I'm Josh Berkus.  As a consultant, I administrate both PostgreSQL and
MS SQL Server profesionally, so I decided to take your question.

> We are considering using Postgre SQL over SQL server.

That's a good first step on the road to freedom from restrictive software
licensing.

> We need
> the trigger*
> *capability.

Which makes PostgreSQL a very good choice.  Between Postgres' multiple
function languages and flexible triggers, and the RULE query-rewriting
system, PostgreSQL  has the most powerful and flexible system for database
automation of any database, period.

Between MS SQL and Postgres, there is no contest.   For me, it is always
horribly frustrating whenever I have to write triggers in MS SQL.

 > However, I am told by a few programmers that Postgre
> operated slower*
> *than say SQL server or other database solutions in the same category.*
> **
> *First, is there any thruth to this?

No, none whatsoever.

MS SQL does a few things faster than PostgreSQL, primarily aggregate querys.
PostgreSQL does more than a few things faster than MS SQL Server, especially
on very low-end and very high-end hardware.

> (We are assuming that all platforms run on all the same servers, hence
> have access*
> *to all the same amount of memory and processing power).*

PostgreSQL's Windows port is still being tested.  If your primary goal is
performance, I strongly recommend that you test PostgreSQL on BSD, Linux, or
mainframe Unix.

Good luck on your evaluation.

--
Josh Berkus
Aglio Database Solutions
San Francisco