On Sat, Nov 13, 2010 at 1:32 AM, Marc Mamin <m.ma...@intershop.de> wrote: > Hello, > > Just a short though: > > Is it imaginable to compare the prognoses of the plans with the actual > results > and somehow log the worst cases ? > > a) to help the DBA locate bad statistics and queries > b) as additional information source for the planner > > This could possibly affect parameters of your formula on the fly. > > best regards, > > Marc Mamin
The contrib module auto_explain might help out here if you wanted to roll your own solution for plan comparison. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
