Re: experiments in query optimization

Поиск
Список
Период
Сортировка
От Matthew Wakeling
Тема Re: experiments in query optimization
Дата
Msg-id alpine.DEB.2.00.1003311028150.9798@aragorn.flymine.org
обсуждение исходный текст
Ответ на Re: experiments in query optimization  (Faheem Mitha <faheem@email.unc.edu>)
Ответы Re: experiments in query optimization  (Faheem Mitha <faheem@email.unc.edu>)
Список pgsql-performance
On Tue, 30 Mar 2010, Faheem Mitha wrote:
>>> work_mem = 1 GB (see diag.{tex/pdf}).
>
> Sure, but define sane setting, please. I guess part of the point is that I'm
> trying to keep memory low

You're trying to keep memory usage low, but you have work_mem set to 1GB?

Matthew

--
"Prove to thyself that all circuits that radiateth and upon which thou worketh
 are grounded, lest they lift thee to high-frequency potential and cause thee
 to radiate also. "             -- The Ten Commandments of Electronics

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

Предыдущее
От: David Wilson
Дата:
Сообщение: Re: query has huge variance in execution times
Следующее
От: Faheem Mitha
Дата:
Сообщение: Re: experiments in query optimization