Re: [GENERAL] Automatic index advisor?

2010-02-27 Thread Greg Smith
Bill Karwin wrote: When I searched for a solution for PostgreSQL, Gurjeet Singh's name came up as the designer of an index adviser patch for PG. But the latest information I found was in 2007. Sort of. That was originally written by Kai-Uwe Sattler:

Re: [GENERAL] Automatic index advisor?

2010-02-27 Thread Bill Karwin
On Feb 27, 2010, at 12:25 AM, Greg Smith wrote: So far, if anybody has done that, they're not talking about it and/ or not releasing it as open-source that I know of. Thanks Greg, it's good to get confirmation of this. I can certainly understand how implementing this feature to a point

[GENERAL] Automatic index advisor?

2010-02-26 Thread Bill Karwin
Hi, I'm writing a book on SQL, with a short section about query tuning and automatic optimization advisors for different RDBMS platforms, for instance, extensions to EXPLAIN that recommend new indexes based on workload and query plans. When I searched for a solution for PostgreSQL,