Re: Reading data in bulk - help?

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: Reading data in bulk - help?
Дата
Msg-id Pine.LNX.4.44.0309101052540.14280-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: Reading data in bulk - help?  (Chris Huston <chuston@bangjafwac.com>)
Список pgsql-performance
On Wed, 10 Sep 2003, Chris Huston wrote:

> Sometime before then I need to figure out how to cut the fetch times
> from the now 200ms to something like 10ms.

You didn't say anything about Joshs first point of adjusting
postgresql.conf to match your machine. Settings like effective_cache_size
you almost always want to increase from the default setting, also shared
memory.

--
/Dennis


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

Предыдущее
От: "Gregory S. Williamson"
Дата:
Сообщение: Re: Hardware recommendations to scale to silly load
Следующее
От: "Mindaugas Riauba"
Дата:
Сообщение: Re: Need advice about triggers