Re: shared_buffers advice

Поиск
Список
Период
Сортировка
От Konrad Garus
Тема Re: shared_buffers advice
Дата
Msg-id AANLkTimVO1B1XhbEcZmtkqrh-68Qd_fStwmJlwN-KlOp@mail.gmail.com
обсуждение исходный текст
Ответ на Re: shared_buffers advice  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Ответы Re: shared_buffers advice  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Список pgsql-performance
2010/5/27 Cédric Villemain <cedric.villemain.debian@gmail.com>:

> well, that is the projection of file in memory. only projection, but
> the memory is still acquire. It is ok to rework this part and project
> something like 128MB and loop. (in fact the code is needed for 9.0
> because segment can be > 1GB, I didn't check what is the optimum
> projection size yet)
> So both yes at your questions :)

So when I map 12 GB, this process will consume 1 GB and the time
needed to browse through the whole 12 GB buffer?

--
Konrad Garus

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Query timing increased from 3s to 55s when used as function instead of select
Следующее
От: David Jarvis
Дата:
Сообщение: Re: Random Page Cost and Planner