| From: | Faheem Mitha <faheem(at)email(dot)unc(dot)edu> |
|---|---|
| To: | Matthew Wakeling <matthew(at)flymine(dot)org> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: experiments in query optimization |
| Date: | 2010-03-31 09:36:11 |
| Message-ID: | alpine.DEB.2.00.1003311505040.13883@orwell.homelinux.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Faheem Mitha | 2010-03-31 10:10:45 | Re: experiments in query optimization |
| Previous Message | Matthew Wakeling | 2010-03-31 09:29:58 | Re: experiments in query optimization |