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

Re: 4s query want to run faster

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Adonias Malosso <malosso(at)gmail(dot)com>
Cc: Claus Guttesen <kometen(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: 4s query want to run faster
Date: 2008-02-21 22:59:06
Message-ID: 47BE023A.6000905@paradise.net.nz (view raw or flat)
Thread:
Lists: pgsql-performance
The other parameter you might want to look at is effective_cache_size - 
increasing it will encourage index use. On a machine with 16GB the 
default is probably too small (there are various recommendations about 
how to set this ISTR either Scott M or Greg Smith had a page somewhere 
that covered this quite well - guys?).

Obviously, decreasing random_page_cost fixed this query for you, but if 
find yourself needing to tweak it again for other queries, then look at 
changing effective_cache_size.

Cheers

Mark


Adonias Malosso wrote:
> Set random_page_cost = 2 solved the problem. thanks
>


In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-02-21 23:16:10
Subject: Re: 4s query want to run faster
Previous:From: Scott MarloweDate: 2008-02-21 21:25:35
Subject: Re: 4s query want to run faster

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