Re: Problem with database performance, Debian 4gb ram ? - Mailing list pgsql-performance

From Jeff Janes
Subject Re: Problem with database performance, Debian 4gb ram ?
Date
Msg-id f67928030911030923i31663c7ew8d75b04874cb568d@mail.gmail.com
Whole thread Raw
In response to Re: Problem with database performance, Debian 4gb ram ?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Problem with database performance, Debian 4gb ram ?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
On Tue, Nov 3, 2009 at 7:13 AM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Grant Masan <grant.massan@gmail.com> wrote:
>
>
>> cpu_tuple_cost = 0.0030
>> cpu_index_tuple_cost = 0.0010
>> cpu_operator_cost = 0.0005
>
> Why did you make these adjustments?  I usually have to change the
> ratio between page and cpu costs toward the other direction.

Is that because the database is mostly cached in memory?  If I take the
documented descriptions of the costs parameters at face value, I find
that cpu_tuple_cost should be even lower yet.


Cheer,

Jeff

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Queryplan within FTS/GIN index -search.
Next
From: David Kerr
Date:
Subject: Optimizer + bind variables