mjy(at)geizhals(dot)at ("Marinos J. Yannikos") writes:
> it seems to me that the optimizer parameters (like random_page_cost
> etc.) could easily be calculated and adjusted dynamically be the DB
> backend based on the planner's cost estimates and actual run times for
> different queries. Perhaps the developers could comment on that?
Yes, it seems like a Small Matter Of Programming.
In seriousness, yes, it would seem a reasonable idea to calculate some
of these values a bit more dynamically.
I would be inclined to start with something that ran a workload, and
provided static values based on how that workload went. That would
require NO intervention inside the DB server; it could be accomplished
simply by writing a database script. Feel free to contribute either a
script or a backend "hack"...
let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];;
(416) 646 3304 x124 (land)
In response to
pgsql-performance by date
|Next:||From: Conny Thimren||Date: 2003-12-18 19:43:29|
|Subject: general performance question|
|Previous:||From: Marinos J. Yannikos||Date: 2003-12-18 18:44:49|
|Subject: why do optimizer parameters have to be set manually?|