[HACKERS] Hypothetical Indexes

2004-10-12 Thread Marcos A Vaz Salles
Hello, I have just finished my M.Sc. thesis at Pontifícia Universidade Católica do Rio de Janeiro (PUC-Rio), Brazil, and we have developed a research prototype for automatic index selection using a software agent in PostgreSQL. In order to make index selection possible, we have extended the Post

Re: [HACKERS] Hypothetical Indexes

2004-10-18 Thread Marcos A Vaz Salles
Tom, > > This would be of some value if the optimizer's cost estimates were > highly reliable, but unfortunately they are far from being so :-( > Without the ability to measure *actual* as opposed to estimated > costs, I'm not sure you can really do much. > In fact, any index selection tool

Re: [HACKERS] Hypothetical Indexes

2004-10-19 Thread Marcos A Vaz Salles
Hello Josh, I will take a look at pgFoundry and register a new project for index selection. I will also look for other projects there that we may help somehow. About the tutorial, I will send you the presentation we used to generate the web pages so that you can see it with OpenOffice. ;) Th