Re: Tuning Postgres 9.1 on Windows

От: Thomas Kellerer
Тема: Re: Tuning Postgres 9.1 on Windows
Дата: ,
Msg-id: jnp4qe$kou$1@dough.gmane.org
(см: обсуждение, исходный текст)
Ответ на: Re: Tuning Postgres 9.1 on Windows  ("Walker, James Les")
Ответы: Re: Tuning Postgres 9.1 on Windows  ("Walker, James Les")
Список: pgsql-performance

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

Tuning Postgres 9.1 on Windows  ("Walker, James Les", )
 Re: Tuning Postgres 9.1 on Windows  (Andy Colson, )
 Re: Tuning Postgres 9.1 on Windows  (Merlin Moncure, )
  Re: Tuning Postgres 9.1 on Windows  (Thomas Kellerer, )
   Re: Tuning Postgres 9.1 on Windows  (Merlin Moncure, )
    Re: Tuning Postgres 9.1 on Windows  ("Walker, James Les", )
     Re: Tuning Postgres 9.1 on Windows  (Merlin Moncure, )
      Re: Tuning Postgres 9.1 on Windows  ("Walker, James Les", )
       Re: Tuning Postgres 9.1 on Windows  (Merlin Moncure, )
        Re: Tuning Postgres 9.1 on Windows  ("Walker, James Les", )
         Re: Tuning Postgres 9.1 on Windows  (Merlin Moncure, )
         Re: Tuning Postgres 9.1 on Windows  (Thomas Kellerer, )
          Re: Tuning Postgres 9.1 on Windows  ("Walker, James Les", )
           Re: Tuning Postgres 9.1 on Windows  ("Walker, James Les", )
      Re: Tuning Postgres 9.1 on Windows  (Andy Colson, )

Walker, James Les wrote on 01.05.2012 16:44:
> I installed the enterprisedb distribution and immediately saw a 400% performance increase.

What exactly is "the enterprisedb distribution"?
Are you talking about the the Advanced Server?

I would be very surprised if the code base would differ so much to allow such a performance gain.
Could it be that the default settings for the Advanced Server are different than those of the "community edition"?

And what did you have installed before that? (as the Windows binary are always distributed by EnterpriseDB)

Thomas


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

От: "Walker, James Les"
Дата:
Сообщение: Re: Tuning Postgres 9.1 on Windows
От: Martin Grotzke
Дата:
Сообщение: Several optimization options (config/hardware)