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 tabl

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.

Re: [PATCHES] WIP: Transportable Optimizer Mode

2008-07-31 Thread chris
[EMAIL PROTECTED] (Simon Riggs) writes: > Comments welcome. A minor change: I'd suggest creating these views as TEMP views, that way they go away automatically. diff -r1.1 create_tom_tables.sql === RCS file: get_data_for_tom.sql,v re

[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