Unanswered: Data encryption using public/private keys
I am currently testing on data encryption in PostgreSQL using pgcrypto lib. However I found that the decryption process is extremely slow when the table data is large (more than 10k). E.g.: for a table with 100k records, the query take more than 10 minutes to get the output.
I am using the encryption mostly on numeric columns and most of the time I am using the aggregate function like SUM to get the total, the query looks like: