Re: [PATCHES] WIP: Transportable Optimizer Mode

2008-08-06 Thread Simon Riggs
On Sat, 2008-08-02 at 20:12 +0100, Simon Riggs wrote: Chris, Thanks for all of those changes... added as suggested (in next version) On Wed, 2008-07-30 at 14:58 -0400, chris wrote: It's not clear to me that the plugin is actually working. When I run EXPLAIN against tables in

Re: [PATCHES] WIP: Transportable Optimizer Mode

2008-08-02 Thread Simon Riggs
Chris, Thanks for all of those changes... added as suggested (in next version) On Wed, 2008-07-30 at 14:58 -0400, chris wrote: It's not clear to me that the plugin is actually working. When I run EXPLAIN against tables in tomtestdb, I get results consistent with an unanalyzed table. So

[PATCHES] WIP: Transportable Optimizer Mode

2008-07-25 Thread Simon Riggs
I've written a contrib module that allows planning information to be extracted from one server and transported to another server to allow SQL analysis: Transportable Optimizer Mode (TOM). TOM works, yet is incomplete because of the lack of a stats hook within the server. So TOM is the application