Chapter 2: Understanding Transactions and Locking What is the purpose of a transaction?

Can PostgreSQL encrypt client connections?

Yes. It is possible to encrypt client/server connections using SSL. All you have to

do is to set a couple of parameters and put certificates on the server. A detailed

guideline is available in this book and in the official PostgreSQL documentation.

Does security impact performance?

It depends on what you are trying to achieve. Nothing is free. However, most

things such as GRANT, REVOKE, and so on have no relevant impact. Other features

such as Row-Level-Security might impact performance in case those security

policies are not written carefully.

---

Assessment