Re: strange performance regression between 7.4 and 8.1

Поиск
Список
Период
Сортировка
От Alex Deucher
Тема Re: strange performance regression between 7.4 and 8.1
Дата
Msg-id a728f9f90703051856s2562f4a4g2fd0ba59f3b97609@mail.gmail.com
обсуждение исходный текст
Ответ на Re: strange performance regression between 7.4 and 8.1  (Guido Neitzer <lists@event-s.net>)
Ответы Re: strange performance regression between 7.4 and 8.1  (Guido Neitzer <lists@event-s.net>)
Список pgsql-performance
On 3/5/07, Guido Neitzer <lists@event-s.net> wrote:
> 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.

Yes, I started setting that up this afternoon.  I'm going to test that
tomorrow and post the results.

Alex

>
> cug
>

В списке pgsql-performance по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Estimate the size of the SQL file generated by pg_dump utility
Следующее
От: Guido Neitzer
Дата:
Сообщение: Re: strange performance regression between 7.4 and 8.1