effective_cache_size patch - Mailing list pgsql-patches

From Simon Riggs
Subject effective_cache_size patch
Date
Msg-id 1099586269.4320.469.camel@localhost.localdomain
Whole thread Raw
Responses Re: effective_cache_size patch  (Simon Riggs <simon@2ndquadrant.com>)
Re: effective_cache_size patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
I enclose a doc patch for the effective_cache_size parameter in
runtime.sgml: efcdoc.patch

Also, another minor patch which prevents effective_cache_size and
random_page_cost from being set incorrectly: plancost.patch
- previously it was possible to set effective_cache_size to 0, which
would then be ignored and treated as 1 at run-time, so set minimum to 1
and remove test at run-time.
- previously it was possible to set random_page_cost as a fractional
value between 0 and 1, which screws up planner estimation, so set
minimum value of 1 (i.e. random cost same as sequential cost).

--
Best Regards, Simon Riggs

Attachment

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: REINDEX doc patch
Next
From: Nicolai Tufar
Date:
Subject: Translation updates for 8.0: postgres-tr