Postgres Pro
Downloads
Home   >   mailing lists

Re: Random Page Cost and Planner - Mailing list pgsql-performance

From Rob Wultsch
Subject Re: Random Page Cost and Planner
Date
Msg-id AANLkTikTDKTxmmN2yhuZCOhSBmekF54ZV991OhVoZelH@mail.gmail.com
Whole thread Raw
In response to Re: Random Page Cost and Planner  (David Jarvis <thangalin@gmail.com>)
Responses Re: Random Page Cost and Planner  (David Jarvis <thangalin@gmail.com>)
List pgsql-performance
Tree view 
On Tue, May 25, 2010 at 4:26 PM, David Jarvis <thangalin@gmail.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@gmail.com

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Random Page Cost and Planner
Next
From: David Jarvis
Date:
Subject: Re: Random Page Cost and Planner