> -----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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
