Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows

От: Andy Colson
Тема: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
Дата: ,
Msg-id: 4D0BA2CB.3090809@squeakycode.net
(см: обсуждение, исходный текст)
Ответ на: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Robert Haas)
Список: pgsql-performance

Скрыть дерево обсуждения

Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Tom Polak, )
 Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  ("Kevin Grittner", )
 Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Andy Colson, )
 Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Andres Freund, )
 Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Craig James, )
 Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Andy Colson, )
  Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Richard Broersma, )
   Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Kenneth Marshall, )
    Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Andy Colson, )
     Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Tom Polak, )
      Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Craig James, )
      Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Gary Doades, )
      Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  ("Kevin Grittner", )
      Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  ("Pierre C", )
       Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Tom Polak, )
        Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Craig James, )
         Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Scott Marlowe, )
          Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Gael Le Mignot, )
           Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Scott Marlowe, )
           Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  ("Pierre C", )
        Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Richard Broersma, )
         Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Justin Pitts, )
        Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Rob Wultsch, )
        Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Robert Haas, )
         Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Andy Colson, )
         Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Tom Polak, )
          Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Robert Haas, )
        Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Andy Colson, )
  Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Gary Doades, )
 Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Mladen Gogala, )

On 12/17/2010 11:37 AM, Robert Haas wrote:
> On Fri, Dec 17, 2010 at 12:08 PM, Tom Polak
> <>  wrote:

> other direction to get good performance, too.  You're not going to
> compare two major database systems across the board and find that one
> of them is just twice as fast, across the board.  They have different
> advantages and disadvantages.  When you're using one product, you
> naturally do things in a way that works well for that product, and
> moving to a different product means starting over.  Oh, putting this
> in a stored procedure was faster on MS SQL, but it's slower on
> PostgreSQL.  Using a view here was terrible on MS SQL, but much faster
> under PostgreSQL.
>

Yeah, totally agree with that.  Every database has its own personality,
and you have to work with it.  Its way.  Dont expect one bit of code to
work great on all the different databases.  You need 5 different bits of
code, one for each database.

In the end, can PG be fast?  Yes.  Very.  But only when you treat is as
PG.  If you try to use PG as if it were mssql, you wont be a happy camper.

-Andy


В списке pgsql-performance по дате сообщения:

От: Robert Haas
Дата:
Сообщение: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
От: Scott Marlowe
Дата:
Сообщение: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows