Postgres Indexes for Newbies

Indexing is key to optimizing your database workloads and reducing query times. Postgres now supports quite a few types of indexes and knowing the basics is a key part of working with Postgres. 

A Postgres Primer for Oracle DBAs

If you've been thrown into the deep end of learning Postgres as your new database system, start here. This blog helps explain the architecture at a high level and some of the key aspects to check to make sure that your new database doesn't have any glaring problems.

PostGIS 3.2 New and Improved

Just under the wire for a 2021 release, the 3.2 version of PostGIS hit the streets! This new PostGIS also supports the latest 3.10 release of GEOS, which underpins a few of the new features.

Elevation Profiles and Flightlines with PostGIS

A question from a community member turned into a nice showcase of Paul Ramsey's favorite spatial tools with indexing, point to point distance queries on a sphere, and nearest neighbor queries. 

Secure Permissions for pgBackRest

The pgBackRest tool is a fantastic backup solution for Postgres, with many features including encryption, compression, automatic expiration, and lots more.This post describes a method of allowing pgBackRest to take a backup with the minimum of access rights for other like-minded security Postgres users.