Re: [HACKERS] GSoC Query

2010-03-29 Thread Gokulakannan Somasundaram
> > > > Similarly using the no. of select hits on a table we can check that if >> maximum no. of times it is on a non-index field we can index on that field >> to make select faster. >> > > It's impractical to figure out where indexes should go at without > simulating what the optimizer would then

Re: [HACKERS] GSoC Query

2010-03-29 Thread Greg Smith
gaurav gupta wrote: My idea is to add a functionality of Auto tuning and Auto Indexing/ Reindexing in DB languages. Ah, the classic request to start with the tuning and index wizards. Really fun to work on, always lots of interest in it. Here's the thing: projects in this area attract endl

Re: [HACKERS] GSoC Query

2010-03-28 Thread Robert Haas
On Sun, Mar 28, 2010 at 10:01 PM, gaurav gupta wrote: > My idea is to add a functionality of Auto tuning and Auto Indexing/ > Reindexing in DB languages. > > Though I am not working on this I have some idea about implementation. > Idea is that on the no. of rows deleted, Inserted in the table we c

[HACKERS] GSoC Query

2010-03-28 Thread gaurav gupta
Sir/Ma'am, I am a Mtech student and want to participate in GSoC. I have a project idea and want to discuss its feasibility, usability and chance of selection with you. My idea is to add a functionality of Auto tuning and Auto Indexing/ Reindexing in DB languages. Though I am not working on t