Re: [HACKERS] Index Tuning Features [2]

2006-10-11 Thread Kai-Uwe Sattler
Hi, Am 11.10.2006 um 19:39 schrieb Simon Riggs: I'm sure everybody would be glad to see the existing work submitted as a Work-in-Progress patch to pgsql-patches. Would a patch against a clean 7.4.8 source tree useful for you? Otherwise, I had to spend some time to migrate the code to 8.2..

Re: [HACKERS] Index Tuning Features [2]

2006-10-11 Thread Simon Riggs
On Wed, 2006-10-11 at 14:30 +0200, Kai-Uwe Sattler wrote: > We have already an implementation of an index advisor for > 7.4.8. > It definitely requires some work to port it to 8.2 and to make it > usable for production environments. > Furthermore, there are some performance bottlenecks (crea

Re: [HACKERS] Index Tuning Features [2]

2006-10-11 Thread Simon Riggs
On Wed, 2006-10-11 at 14:30 +0200, Kai-Uwe Sattler wrote: > sorry for opening a new thread but I have just subscribed to the > list. Not at all, glad to hear about your implementation. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end

[HACKERS] Index Tuning Features [2]

2006-10-11 Thread Kai-Uwe Sattler
Hi, sorry for opening a new thread but I have just subscribed to the list. We have already an implementation of an index advisor for 7.4.8. This is the result of several master theses, so it's no production ready yet, but it works (with some limitations). The main idea is: 1. to run the pl