Re: performance question (something to do w/ parameterized

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Jeffrey Tenny <jeffrey(dot)tenny(at)comcast(dot)net> writes:
> The server was already running with random_page_cost=2 today for all tests, because of
> the mods I've made to improve other problem queries in the past (my settings noted below, and
> before in another msg on this topic).

> So to nail this particular query something additional is required (even lower random_page_cost?).
> What's a good value for slower processors/memory and database in memory?

If you're pretty sure the database will always be RAM-resident, then 1.0
is the theoretically correct value.

			regards, tom lane