Re: Why the index is not used ?

Francisco Olarte <[email protected]> Sun, 7 Oct 2018 17:58:29 +0200

Newsgroups	gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.performance,gmane.comp.db.postgresql.general
Message-ID	<CA+bJJbxJuM4RQ=qMwQOF4Gep+y4w6a0Ym_ta7e_NBZH0p1sC2w@mail.gmail.com>

ROS:

On Sun, Oct 7, 2018 at 3:13 PM, ROS Didier <[email protected]> wrote:
....
> -        INSERT INTO cartedecredit(username,cc)  SELECT 'individu ' || x.id, pgp_sym_encrypt('test value ' || x.id, 'motdepasse','compress-algo=2, cipher-algo=aes256') FROM generate_series(1,100000) AS x(id);
> -        CREATE INDEX idx_cartedecredit_cc02 ON cartedecredit(pgp_sym_decrypt(cc, 'motdepasse','compress-algo=2, cipher-algo=aes256'));

If my french is not too rusty you are encrypting a credit-card, and
then storing an UNENCRYPTED copy in the index. So, getting it from the
server is trivial for anyone with filesystem access.

Francisco Olarte.