Re: [PERFORM] Reasonable amount of indices

2007-09-06 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Patric wrote: >> My Question now is: Is it wise to do so, and create hundreds or maybe >> thousands of Indices >> which partition the table for the selections. > No, this is not helpful -- basically what you are doing is taking the > first level (the f

Re: [PERFORM] Reasonable amount of indices

2007-09-06 Thread Alvaro Herrera
Patric wrote: >My Question now is: Is it wise to do so, and create hundreds or maybe > thousands of Indices >which partition the table for the selections. No, this is not helpful -- basically what you are doing is taking the first level (the first couple of levels maybe) of the index out