Tom Allison wrote: > Does is make sense to add yet another index? Since postgres performs better with than without, is that in question?
> or to ensure that all the userid records are inserted as lowercase only? That only works if you make damn sure there aren't any reasons for doing things mixed case. I'm not saying there are any - just that it needs careful deliberation and a lot of QA testing on a stable branch. Also, we can never be too certain about the source of the inserted records. Perhaps a trigger that would force the lower-case could cover that though. So: yes, my hunch is you have a case, but only if the trigger is provided as well. > > I would think that the existing index can be made to work with a > modification to the INSERT/UPDATE SQL and not have to go through the > process of building out two nearly identical indexes. We can work on this on the trunk. Could you please file a wishlist bug, so I won't forget about this? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
