Skip site navigation (1) Skip section navigation (2)

Re: bad planning with 75% effective_cache_size

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Istvan Endredy" <istvan(dot)endredy(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: bad planning with 75% effective_cache_size
Date: 2012-04-05 15:41:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Istvan Endredy <istvan(dot)endredy(at)gmail(dot)com> wrote:
> i've ran into a planning problem.
> If effective_cache_size has a greater value (6GB), this select has
> a bad planning and long query time (2000ms):
Could you try that configuration with one change and let us know how
it goes?:
set cpu_tuple_cost = '0.05';
I've seen an awful lot of queries benefit from a higher value for
that setting, and I'm starting to think a change to that default is
in order.

In response to


pgsql-performance by date

Next:From: Tomas VondraDate: 2012-04-05 15:49:56
Subject: Re: H800 + md1200 Performance problem
Previous:From: Gregg JaskiewiczDate: 2012-04-05 15:39:26
Subject: heavly load system spec

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group