Re: limiting query time and/or RAM

Поиск
Список
Период
Сортировка
От Alan McKay
Тема Re: limiting query time and/or RAM
Дата
Msg-id 844129e80909171219vfe19044k989e2638bf7c765f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: limiting query time and/or RAM  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: limiting query time and/or RAM  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
> Generally speaking work_mem limits ram used.  What are your
> non-default postgresql.conf settings?

This cannot be right because we had queries taking 4G and see our
setting is such :

work_mem = 2MB                          # min 64kB

I'll have to find a copy of the default file to figure out what my
non-defaults are

--
“Don't eat anything you've ever seen advertised on TV”
         - Michael Pollan, author of "In Defense of Food"

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: limiting query time and/or RAM
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: limiting query time and/or RAM