Re: Why could different data in a table be processed with different performance?

Поиск
Список
Период
Сортировка
От Vladimir Ryabtsev
Тема Re: Why could different data in a table be processed with different performance?
Дата
Msg-id CAMqTPqmRwpy2_hgD=Fic7VVgjEcp4D2O0RCyBPitoUMEqpcApQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why could different data in a table be processed with differentperformance?  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
Дерево обсуждения
> Does your LVM have readahead
> ramped up ?  Try lvchange -r 65536 data/postgres (or similar).

Changed this from 256 to 65536.
If it is supposed to take effect immediately (no server reboot or other changes), then I've got no changes in performance. No at all.

Vlad

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

Предыдущее
От: "Sam R."
Дата:
Сообщение: Re: To keep indexes in memory, is large enough effective_cache_sizeenough?
Следующее
От: Vladimir Ryabtsev
Дата:
Сообщение: Re: Why could different data in a table be processed with different performance?