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.