Re: What about utility to calculate planner cost constants?

> -----Original Message-----
> From: Dave Held
> Sent: Tuesday, March 22, 2005 4:16 PM
> To: Tom Lane
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] What about utility to calculate planner cost
> constants?
> [...]
> Then instead of building a fixed cost model, why not evolve
> an adaptive model using an ANN or GA?
> [...]

Another advantage to an adaptive planner is that for those who
can afford to duplicate/replicate their hardware/db, they can
perhaps dedicate a backup server to plan optimization where the
db just runs continuously in a learning mode trying out different
plans for a core set of important queries.  Then those network
parameters can get replicated back to the primary server(s),
hopefully improving query planning on the production dbs.  And
perhaps people could make those parameters public, with the hope
that someone with a similar setup could benefit from a pre-
learned network.

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East,  Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129