Is it a feasible idea that PostgreSQL could detect when an index would be handy, and create it itself, or at least log that a table is being queried but the indices are not appropriate? I suggest this as it's a feature of most windows databases, and MySQL does it. I think it would be a great timesaver as we have hundreds of different queries, and it's a real pain to have to EXPLAIN them all, etc. Is that possible? Feasible? Chris -- Christopher Kings-Lynne Family Health Network (ACN 089 639 243)
- Re: [HACKERS] Auto-indexing Christopher Kings-Lynne
- Re: [HACKERS] Auto-indexing Alfred Perlstein
- Re: [HACKERS] Auto-indexing Bruce Momjian