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 "tomtestdb", I get results > > consistent with an unanalyzed table. So possibly the "hook" isn't > > being used. Perhaps I'm using it wrongly; perhaps what I have > > documented above may suggest to you what's broken. > > The plugin works, but it currently extracts 0 for number of tuples. So > you need to override that to give a different answer. > > I was going to add an SQL function to estimate the number of tuples in > the same way as the optimizer does. That way we get the same answer from > the EXPLAIN as we would have got on the main server and we don't need to > run select count(*) against each table (unless we want to).
New version submitted together with stats hook patch on other thread. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches
