Author - Robert Bernier

A Snippet of Features: Reviewing PostgreSQL Version 13

Reviewing PostgreSQL Version 13

This latest and greatest version of PostgreSQL, version 13, has been here since last summer and continues the tradition of gains in performance, administration, application development, and security enhancements.
Of the many new features and enhancements that have been made, some of the more notable ones include:

Space savings and performance gains from de-duplication of B-tree […]

Read more

PostgreSQL Configuration Changes You Need to Make Post-Installation

PostgreSQL Configuration Changes

So you’ve installed postgres onto your machine, and you want to start working with it.
How?
The key to understanding the post-installation procedure is to realize that it “depends”.

It “depends” on the OS i.e. MSWindows vs Linux.
It “depends” on the flavor of Linux i.e. Debian vs RedHat.
It “depends” if it’s a package install or from source […]

Read more

Top 7 Reasons Why Security Goes Wrong In A Database System

Why Security Goes Wrong In A Database System

Today I’m going to talk about my favorite trope, “database security”.
When done right, a good security policy not only protects your data but improves performance, system stability, and enhances the development life-cycle. When done wrong it not only risks the confidentiality and integrity of your data but it leaves your organization open to significant […]

Read more

PostgreSQL Security Missteps and Tips

postgresql security tips

Security, when done right, not only protects your data but improves performance, system stability, and enhances the development life-cycle. Because PostgreSQL security can easily become an all-encompassing activity, we’ll deal with the most common mechanisms.
Three files control security in the postgres data cluster but for our purposes, we’ll deal only with postgresql.conf and pg_hba.conf, […]

Read more

Removing PostgreSQL Bottlenecks Caused by High Traffic

PostgreSQL Bottlenecks High Traffic

Taking our cue from Peter Zaitsev’s article on MySQL Performance Bottlenecks, I’m going to talk a little about the PostgreSQL perspective of removing bottlenecks caused by high traffic.
Many stacks these days are implemented by trusting the Object Relational Mapper, ORM, to do the right thing with PostgreSQL while one creates critical business logic on […]

Read more