Re: Allow sorts to use more available memory

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Allow sorts to use more available memory
Дата
Msg-id 201110052154.p95LsHs02311@momjian.us
обсуждение исходный текст
Ответ на Re: Allow sorts to use more available memory  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-performance
Stephen Frost wrote:
-- Start of PGP signed section.
> * Robert Schnabel (schnabelr@missouri.edu) wrote:
> > And getting back to the to-do list entry and reading the related
> > posts, it appears that even if you could set work_mem that high it
> > would only use 2GB anyway.  I guess that was the second part of my
> > question.  Is that true?
>
> Errr, and to get back to the to-do (which I've been considering doing
> something about...), it's to allow the *actual* memory usage for things
> like sorts to use more than 2GB, but as others have pointed out, you can
> do that by putting pgsql_tmp on a memory filesystem and letting the
> sorts spill to the memory-based FS.

It would be nice if the tempfs would allow us to control total temp
memory usage, except it causes a failure rather than splilling to real
disk.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

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

Предыдущее
От: David Boreham
Дата:
Сообщение: Intel 710 Endurance Test Results
Следующее
От: Ben Ciceron
Дата:
Сообщение: pg9 replication over WAN ?