Re: Random Page Cost and Planner

From: Rob Wultsch <wultsch(at)gmail(dot)com>
To: David Jarvis <thangalin(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Random Page Cost and Planner
Date: 2010-05-26 00:56:58
Message-ID: AANLkTikTDKTxmmN2yhuZCOhSBmekF54ZV991OhVoZelH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, May 25, 2010 at 4:26 PM, David Jarvis <thangalin(at)gmail(dot)com> wrote:
> shared_buffers = 1GB
> temp_buffers = 32MB
> work_mem = 32MB
> maintenance_work_mem = 64MB
> effective_cache_size = 256MB

Shouldn't effective_cache_size be significantly larger?

--
Rob Wultsch
wultsch(at)gmail(dot)com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Jarvis 2010-05-26 03:50:09 Re: Random Page Cost and Planner
Previous Message Tom Lane 2010-05-26 00:24:23 Re: Random Page Cost and Planner