Re: Poor performance on seq scan

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема Re: Poor performance on seq scan
Дата
Msg-id 450871C9.1010709@fer.hr
обсуждение исходный текст
Ответ на Poor performance on seq scan  (Laszlo Nagy <gandalf@designaproduct.biz>)
Список pgsql-performance
pgsql-performance-owner@postgresql.org wrote:

> This board has Intel chipset. I cannot remember the exact type but it
> was not in the low end category.
> dmesg says:
>
> <Intel ICH7 SATA300 controller>
> kernel: ad4: 152626MB <SAMSUNG HD160JJ ZM100-33> at ata2-master SATA150
> kernel: ad4: 152627MB <SAMSUNG HD160JJ ZM100-33> at ata3-master SATA150

There have been reported problems with ICH7 on FreeBSD mailing lists,
though I can't find any that affect performance.

> Components: 2
> Balance: round-robin
> Slice: 4096

See if changing balance algorithm to "split", and slice size to 8192 or
more, while keeping vfs.read_max to 16 or more helps your performance.

(e.g. gmirror configure -b split -s 8192 gm0)

Also, how is your file system mounted? (what does output from 'mount' say?)

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

Предыдущее
От: "Joshua Marsh"
Дата:
Сообщение: Re: Performance With Joins on Large Tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance With Joins on Large Tables