Why the index is not used ?

2018-10-06 Thread ROS Didier
Hi I would like to submit the following problem to the PostgreSQL community. In my company, we have data encryption needs. So I decided to use the following procedure : (1)Creating a table with a bytea type column to store the encrypted data CREATE TABLE cartedecredit(card_id SERIAL PRIMARY

RE: Why the index is not used ?

2018-10-07 Thread ROS Didier
f.fr<mailto:[email protected]> Tél. : 01 78 66 61 14 Tél. mobile : 06 49 51 11 88 Lync : [email protected] De : [email protected] [mailto:[email protected]] Envoyé : samedi 6 octobre 2018 12:14 À : ROS Didier Cc : [email protected]; [email protected]

RE: Why the index is not used ?

2018-10-07 Thread ROS Didier
lmcgarry.com] Envoyé : dimanche 7 octobre 2018 04:21 À : ROS Didier Cc : [email protected]; [email protected]; [email protected] Objet : Re: Why the index is not used ? I haven’t looked up what pgp_sym_encrypt() does but assuming it does encryption

RE: Why the index is not used ?

2018-10-07 Thread ROS Didier
t Regards Didier ROS -Message d'origine- De : [email protected] [mailto:[email protected]] Envoyé : dimanche 7 octobre 2018 17:58 À : ROS Didier Cc : [email protected]; [email protected]; [email protected]; [email protected]

RE: Why the index is not used ?

2018-10-07 Thread ROS Didier
@gmail.com [mailto:[email protected]] Envoyé : dimanche 7 octobre 2018 21:33 À : ROS Didier Cc : [email protected]; [email protected]; [email protected]; [email protected]; [email protected] Objet : Re: Why the index is not used ? Addition

RE: Why the index is not used ?

2018-10-08 Thread ROS Didier
[email protected] [mailto:[email protected]] Envoyé : dimanche 7 octobre 2018 20:41 À : ROS Didier ; [email protected] Cc : [email protected]; [email protected]; [email protected]; [email protected] Objet : RE: Why the index is not

RE: Why the index is not used ?

2018-10-08 Thread ROS Didier
octobre 2018 18:51 À : ROS Didier Cc : [email protected]; [email protected]; [email protected] Objet : Re: Why the index is not used ? Hello Didier, >> (3), (5) to find the match, you decrypt the whole table, apparently this take quite

RE: Why the index is not used ?

2018-10-08 Thread ROS Didier
s Didier De : [email protected] [mailto:[email protected]] Envoyé : dimanche 7 octobre 2018 21:33 À : ROS Didier Cc : [email protected]; [email protected]; [email protected]; [email protected]; [email protected] Objet : Re: Why

RE: Why the index is not used ?

2018-10-08 Thread ROS Didier
.com [mailto:[email protected]] Envoyé : dimanche 7 octobre 2018 22:08 À : ROS Didier ; [email protected] Cc : [email protected]; [email protected]; [email protected]; [email protected] Objet : Re: Why the index is not used ? Hi

RE: Why the index is not used ?

2018-10-08 Thread ROS Didier
am going to test it. Best Regards Didier ROS De : [email protected] [mailto:[email protected]] Envoyé : lundi 8 octobre 2018 00:11 À : ROS Didier Cc : [email protected]; [email protected]; [email protected]; [email protected]; pgsql-gene

How to get the content of Bind variables

2019-02-28 Thread ROS Didier
Hi In the log file of my PostgreSQL cluster, I find : >> Statement: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 << è how to get the content of the bind va

RE: How to get the content of Bind variables

2019-02-28 Thread ROS Didier
E20.1EAF68B0] De : [email protected] [mailto:[email protected]] Envoyé : jeudi 28 février 2019 13:37 À : ROS Didier Cc : [email protected] Objet : Re: How to get the content of Bind variables If you set log_min_duration_statement low enough for your particular query, y

RE: How to get the content of Bind variables

2019-02-28 Thread ROS Didier
Département Solutions Groupe Groupe Performance Applicative 32 avenue Pablo Picasso 92000 NANTERRE   [email protected] Tél. : +33 6 49 51 11 88 -Message d'origine- De : [email protected] [mailto:[email protected]] Envoyé : jeudi 28 février 2019 17:01 À : ROS Didier

RE: How to get the content of Bind variables

2019-02-28 Thread ROS Didier
t.com] Envoyé : jeudi 28 février 2019 17:19 À : ROS Didier Cc : [email protected] Objet : Re: How to get the content of Bind variables On Thu, Feb 28, 2019 at 12:21:56PM +0000, ROS Didier wrote: > Statement: update t_shared_liste_valeurs set deletion_date=$1, > deleti

RE: How to get the content of Bind variables

2019-03-01 Thread ROS Didier
l. : +33 6 49 51 11 88 -Message d'origine- De : [email protected] [mailto:[email protected]] Envoyé : vendredi 1 mars 2019 17:30 À : ROS Didier Cc : [email protected]; [email protected] Objet : Re: How to get the content of Bind variables ROS Didier writes:

RE: How to get the content of Bind variables

2019-03-02 Thread ROS Didier
Hi The SQL is not executed from a trigger. Here is an extract of my log file : >> 2019-03-01 14:53:37 CET [24803]: [129-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3711 after 1000.476 ms 2019

RE: How to get the content of Bind variables

2019-03-02 Thread ROS Didier
edi 2 mars 2019 16:57 À : ROS Didier Cc : [email protected]; [email protected]; [email protected] Objet : Re: How to get the content of Bind variables On Fri, Mar 01, 2019 at 06:47:06PM +0000, ROS Didier wrote: > log_line_prefix = '%t [%p]: [%l-1] [%x] user=%u,db

RE: How to get the content of Bind variables

2019-03-02 Thread ROS Didier
e : [email protected] [mailto:[email protected]] Envoyé : samedi 2 mars 2019 17:34 À : ROS Didier ; [email protected]; [email protected] Objet : Re: How to get the content of Bind variables Hello Postgresql does not log statement parameters on log_lock_wait. Because this is