Re: experiments in query optimization

Список
Период
Сортировка
От Faheem Mitha
Тема Re: experiments in query optimization
Дата
Msg-id alpine.DEB.2.00.1003311505040.13883@orwell.homelinux.org
обсуждение исходный текст
Ответ на Re: experiments in query optimization  (Matthew Wakeling)
Список pgsql-performance
Дерево обсуждения
experiments in query optimization  (Faheem Mitha, )
 Re: experiments in query optimization  (Robert Haas, )
  Re: experiments in query optimization  (Faheem Mitha, )
   Re: experiments in query optimization  (Robert Haas, )
    Re: experiments in query optimization  (Faheem Mitha, )
   Re: experiments in query optimization  ("Kevin Grittner", )
    Re: experiments in query optimization  (Faheem Mitha, )
     Re: experiments in query optimization  (Robert Haas, )
      Re: experiments in query optimization  (Faheem Mitha, )
       Re: experiments in query optimization  (Robert Haas, )
       Re: experiments in query optimization  (Faheem Mitha, )
        Re: experiments in query optimization  (Eliot Gable, )
         Re: experiments in query optimization  (Faheem Mitha, )
          Re: experiments in query optimization  (Robert Haas, )
           Re: experiments in query optimization  (Faheem Mitha, )
            Re: experiments in query optimization  (Eliot Gable, )
             Re: experiments in query optimization  (Faheem Mitha, )
     Re: experiments in query optimization  (Matthew Wakeling, )
      Re: experiments in query optimization  (Faheem Mitha, )
    Re: experiments in query optimization  (Faheem Mitha, )

On Wed, 31 Mar 2010, Matthew Wakeling wrote:

> 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?

I'm trying to keep both runtime and memory usage low. I assume that with
lower levels of memory, the runtime would be longer, other things being
equal.
                                                          Regards, Faheem.

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: experiments in query optimization
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: 3ware vs. MegaRAID