On 06/29/2013 09:24 AM, bhanu udaya wrote:
Upper and Lower functions are not right choice when the table is > 2.5
million and where we also have heavy insert transactions.
Prove it. Seriously, just run a test case against it. See how it works
for you. Inserts are generally a very inexpensive
On 06/28/2013 03:21 AM, bhanu udaya wrote:
Hello,
Grettings,
What is the best way of doing case insensitive searches in postgres
using Like.
Ilike - does not use indexes
function based indexes are not as fast as required.
CITEXT - it still taking 600 ms - 1 second on a 2.2 million rows... doe
Dave Page wrote:
Just a heads up - I'm spending some time in Paris from Sunday to
Thursday next week and probably won't be reading email or carrying my
cellphone over that period.
Glad to hear someone can turn off their cell phone :)
Regards, Dave.
---(end of broadca
