| From: | Vladimir Ryabtsev <greatvovan(at)gmail(dot)com> |
|---|---|
| To: | didier(dot)ros(at)edf(dot)fr |
| Cc: | folarte(at)peoplecall(dot)com, pavel(dot)stehule(at)gmail(dot)com, pgsql-sql(at)lists(dot)postgresql(dot)org, pgsql-performance(at)lists(dot)postgresql(dot)org, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Why the index is not used ? |
| Date: | 2018-10-07 19:32:46 |
| Message-ID: | CAMqTPqkE-+m9R3AUpXu-4n-JjEV0WO8W8UChSXjyyosdjLgLzg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2018-10-07 20:07:44 | Re: Why the index is not used ? |
| Previous Message | Phil Endecott | 2018-10-07 19:17:51 | RE: Why the index is not used ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2018-10-07 20:07:44 | Re: Why the index is not used ? |
| Previous Message | Vladimir Ryabtsev | 2018-10-07 18:48:20 | Re: Why the index is not used ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2018-10-07 20:07:44 | Re: Why the index is not used ? |
| Previous Message | Vladimir Ryabtsev | 2018-10-07 18:48:20 | Re: Why the index is not used ? |