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). -- 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