Re: experiments in query optimization - Mailing list pgsql-performance

From Faheem Mitha
Subject Re: experiments in query optimization
Date
Msg-id alpine.DEB.2.00.1003311505040.13883@orwell.homelinux.org
Whole thread Raw
In response to Re: experiments in query optimization  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance

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 by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: experiments in query optimization
Next
From: Faheem Mitha
Date:
Subject: Re: experiments in query optimization