Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9R9U-0004K4-4y for pgsql-general@arkaria.postgresql.org; Mon, 08 Oct 2018 08:44:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9R9S-0003W2-Ag for pgsql-general@arkaria.postgresql.org; Mon, 08 Oct 2018 08:44:30 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9R9R-0003Vv-MS for pgsql-general@lists.postgresql.org; Mon, 08 Oct 2018 08:44:29 +0000 Received: from heaven.argudo.org ([195.154.250.235]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9R9O-0000cH-Bf for pgsql-general@lists.postgresql.org; Mon, 08 Oct 2018 08:44:28 +0000 Received: by heaven.argudo.org (Postfix, from userid 1008) id 7D6641500A73; Mon, 8 Oct 2018 10:44:23 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on heaven.argudo.org X-Spam-Level: X-Spam-Status: No, score=-1.0 required=5.0 tests=ALL_TRUSTED,URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.0 Received: from deiphobe (maison [78.229.44.71]) (Authenticated sender: jpa) by heaven.argudo.org (Postfix) with ESMTPSA id D94941500A2D for ; Mon, 8 Oct 2018 10:44:22 +0200 (CEST) Message-ID: <3566caf6e5e20665c48b2b9b9e61df57e21fd83b.camel@argudo.org> Subject: Re: Why the index is not used ? From: Jean-Paul Argudo To: pgsql-general@lists.postgresql.org Date: Mon, 08 Oct 2018 10:44:22 +0200 In-Reply-To: References: <74090066a33740ea8fc442cc70f8afa2@PCYINTPEXMU001.NEOPROD.EDF.FR> <3a14f7f8fbda4e868b663b31e8c5fa16@PCYINTPEXMU001.NEOPROD.EDF.FR> <064a89d526c44d45ae43a37556c6b5f1@USFKL11XG20CN01.mercer.com> Organization: PostgreSQL Fr Content-Type: text/plain; charset="ISO-8859-15" X-Mailer: Evolution 3.28.5-0ubuntu0.18.04.1 Mime-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Dear Didier, Le lundi 08 octobre 2018 à 08:32 +0000, ROS Didier a écrit : > Hi Virendra > You think that outside encryption of the database is the best solution ? > How do you manage the encryption key ? > Can you give me some examples of this kind of solution. > Best Regards > Didier ROS If I understand your need well, you need to store credit card information into your database. This is ruled by the Payment Card Industry Data Security Standard (aka PCI DSS). I attend some years ago a real good presentation from Denish Patel, a well known community member. I saw this talk in pgconf 2015 in Moscow: https://pgconf.ru/media2015c/patel.pdf I recommend you read it, if you had not already? It shows code examples, etc. My 2 cents... -- Jean-Paul Argudo