Jeffrey Tenny <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
