3 ms·
> Isn't a more common and general solution to the first problem to index the expression lower(email) (1). OP mentions & dismisses it in passing before the prop
by OJFord 5y ago
> Isn't a more common and general solution to the first problem to index the expression lower(email) (1).
OP mentions & dismisses it in passing before the proposed solutions:
> A query searching by a function cannot use a standard index. So you’d need to add a custom index for it to be efficient. But, adding custom indexes on a per-query basis is not a very scalable approach. You might find yourself with multiple redundant indexes that significantly slow down the write operations.