From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | Arjen van der Meijden <acmmailing(at)tweakers(dot)net>, Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Hints proposal |
Date: | 2006-10-12 21:41:11 |
Message-ID: | 20061012214111.90031.qmail@web31807.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
> By the way, wouldn't it be possible if the planner learned from a query
> execution, so it would know if a choice for a specific plan or estimate
> was actually correct or not for future reference? Or is that in the line
> of DB2's complexity and a very hard problem and/or would it add too much
> overhead?
Just thinking out-loud here...
Wow, a learning cost based planner sounds a-lot like problem for control & dynamical systems
theory. As I understand it, much of the advice given for setting PostgreSQL's tune-able
parameters are from "RULES-OF-THUMB." I am sure that effect on server performance from all of the
parameters could be modeled and an adaptive feed-back controller could be designed to tuned these
parameters as demand on the server changes.
Al-thought, I suppose that a controller like this would have limited success since some of the
most affective parameters are non-run-time tune-able.
In regards to query planning, I wonder if there is way to model a controller that could
adjust/alter query plans based on a comparison of expected and actual query execution times.
Regards,
Richard Broersma Jr.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-10-12 22:02:07 | Re: [HACKERS] Hints proposal |
Previous Message | Bruce Momjian | 2006-10-12 21:29:15 | Re: create temp table .. on commit delete rows |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-10-12 22:02:07 | Re: [HACKERS] Hints proposal |
Previous Message | Tom Lane | 2006-10-12 21:28:48 | Re: Hints proposal |