On Thu, 2005-08-25 at 21:27 -0400, Andrew Dunstan wrote: > > Rod Taylor wrote: > > > * Multi-CPU sorts. Take a large single sort like an index creation > > and split the work among multiple CPUs.
> This really implies threading, doesn't it? And presumably it would have > many possible uses besides this one for doing parallel work, e.g. maybe > the planner could evaluate several alternative plans in parallel. I don't think threading is needed. I pictured PostgreSQL spawning one process per CPU explicitly for sorting which standard backends could use as required to do batch work. Not necessarily easy to do but it would sure be handy. -- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
