Re: Why the index is not used ?

Поиск
Список
Период
Сортировка
От Vladimir Ryabtsev
Тема Re: Why the index is not used ?
Дата
Msg-id CAMqTPqkE-+m9R3AUpXu-4n-JjEV0WO8W8UChSXjyyosdjLgLzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why the index is not used ?  (Vladimir Ryabtsev <greatvovan@gmail.com>)
Ответы RE: Why the index is not used ?  (ROS Didier <didier.ros@edf.fr>)
RE: Why the index is not used ?  (ROS Didier <didier.ros@edf.fr>)
RE: Why the index is not used ?  (ROS Didier <didier.ros@edf.fr>)
RE: Why the index is not used ?  (ROS Didier <didier.ros@edf.fr>)
RE: Why the index is not used ?  (ROS Didier <didier.ros@edf.fr>)
RE: Why the index is not used ?  (ROS Didier <didier.ros@edf.fr>)
Список pgsql-sql
Additionally it is not clear why you want to search in table on encrypted data. Usually you match user with it's unpersonalized data (such as login, user ID) and then decrypt personalized data. If you need to store user identifying data encrypted as well (e.g. bank account number) you can use a deterministic algorithm for it (without salt) because it is guaranteed to be unique and you don't need to have different encrypted data for two same input strings.

Vlad

В списке pgsql-sql по дате отправления:

Предыдущее
От: Vladimir Ryabtsev
Дата:
Сообщение: Re: Why the index is not used ?
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Why the index is not used ?