[PERFORM] Reasonable amount of indices

2007-09-06 Thread Patric
Hi, I've a question about amount of indices. I explain my issue based on an example: Table which contains person information, one row per person. There will be lots of SELECTS doing search by special criteria, e.g.: Age, Gender. Now there will be 4 User groups which will

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

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 first