Re: Sanity check requested

Поиск
Список
Период
Сортировка
От Nick Fankhauser
Тема Re: Sanity check requested
Дата
Msg-id NEBBLAAHGLEEPCGOBHDGOEFEHMAA.nickf@ontko.com
обсуждение исходный текст
Ответ на Re: Sanity check requested  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Sanity check requested
Список pgsql-performance
> Wrong, actually.   Sort memory is allocated *per sort*, not per
connnection or
> per query.   So a single complex query could easily use 4xsort_mem if it
has
> several merge joins ...

Thanks for the correction- it sounds like this is one where usage can't be
precisely controlled in a dynamic user environment & I just need to get a
feel for what works under a load that approximates my production system.

-Nick


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

Предыдущее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: Hardware performance
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Relation of indices to ANALYZE