Re: Why the index is not used ? - Mailing list pgsql-sql

From Vladimir Ryabtsev
Subject Re: Why the index is not used ?
Date
Msg-id CAMqTPqkE-+m9R3AUpXu-4n-JjEV0WO8W8UChSXjyyosdjLgLzg@mail.gmail.com
Whole thread Raw
In response to Re: Why the index is not used ?  (Vladimir Ryabtsev <greatvovan@gmail.com>)
Responses 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>)
List 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 by date:

Previous
From: Vladimir Ryabtsev
Date:
Subject: Re: Why the index is not used ?
Next
From: Tomas Vondra
Date:
Subject: Re: Why the index is not used ?