Re: strange performance regression between 7.4 and 8.1

От: Guido Neitzer
Тема: Re: strange performance regression between 7.4 and 8.1
Дата: ,
Msg-id: 2D7248A6-38DB-4FE2-A570-6476D5985E85@event-s.net
(см: обсуждение, исходный текст)
Ответ на: strange performance regression between 7.4 and 8.1  ("Alex Deucher")
Ответы: Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher")
Список: pgsql-performance

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

strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
 Re: strange performance regression between 7.4 and 8.1  (Guido Neitzer, )
  Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
   Re: strange performance regression between 7.4 and 8.1  (Guido Neitzer, )
    Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
 Re: strange performance regression between 7.4 and 8.1  (Ron, )
  Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
   Re: strange performance regression between 7.4 and 8.1  ("Rodrigo Madera", )
    Re: strange performance regression between 7.4 and 8.1  ("Craig A. James", )
     Re: strange performance regression between 7.4 and 8.1  (Ron, )
      Re: strange performance regression between 7.4 and 8.1  (Carlos Moreno, )
     Re: strange performance regression between 7.4 and 8.1  (Carlos Moreno, )
      Re: strange performance regression between 7.4 and 8.1  ("Craig A. James", )

On 01.03.2007, at 13:40, Alex Deucher wrote:

> I read several places that the SAN might be to blame, but
> testing with bonnie and dd indicates that the SAN is actually almost
> twice as fast as the scsi discs in the old sun server.  I've tried
> adjusting just about every option in the postgres config file, but
> performance remains the same.  Any ideas?

As mentioned last week:

Did you actually try to use the local drives for speed testing? It
might be that the SAN introduces latency especially for random access
you don't see on local drives.

cug


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

От: Richard Huxton
Дата:
Сообщение: Re: Insert performance
От: Richard Huxton
Дата:
Сообщение: Re: Insert performance