Planner constants for RAM resident databases - Mailing list pgsql-performance

From Emil Briggs
Subject Planner constants for RAM resident databases
Date
Msg-id 200507012159.39041.emil@baymountain.com
Whole thread Raw
Responses Re: Planner constants for RAM resident databases
Re: Planner constants for RAM resident databases
List pgsql-performance
I'm working with an application where the database is entirely resident in RAM
(the server is a quad opteron with 16GBytes of memory). It's a web
application and handles a high volume of queries. The planner seems to be
generating poor  plans for some of our queries which I can fix by raising
cpu_tuple_cost. I have seen some other comments in the archives saying that
this is a bad idea  but is that necessarily the case when the database is
entirely resident in RAM?

Emil

pgsql-performance by date:

Previous
From: John Mendenhall
Date:
Subject: Re: ported application having performance issues
Next
From: Steve Atkins
Date:
Subject: Re: Planner constants for RAM resident databases