Latest posts from Elizabeth Christensen
Postgres TOAST: The Greatest Thing Since Sliced Bread?
Elizabeth gives us an overview of the Postgres TOAST (The Oversized Attribute Storage Technique) system and what it means for your data types and storage.
PostGIS Day 2023 Summary
Highlights and notes from this year's PostGIS day talks including the ideal GIS stack, PostGIS for emergency services, MobilityDB, and PostGIS functions for Star Wars.
Working with Money in Postgres
Elizabeth has a primer for working with money in Postgres including what data type to choose, storing currency, and some sample functions.
Top 10 Postgres Management Tasks
The must know Postgres management tasks to look at for any scale. Plus a bonus image included showing the recent and upcoming Postgres release schedule.
Postgres Subquery Powertools: CTEs, Materialized Views, Window Functions, and LATERAL Join
Wondering when to use a Materialized View or a CTE? Elizabeth has summaries, example queries, and comparisons for the most popular subquery tools.
10 min readData Skews in Postgres
Skewed or uneven data is common in Postgres. Elizabeth has a quick query for finding your data distributions and recommendations on fixing indexes if you have skewed data.
Working with Time in Postgres
A primer on working with time in Postgres. Covers data types, query formats, intervals, overlaps, range types, indexing, and roll ups.
Intro to Postgres Custom Data Types
A quick primer on the two main ways to create custom data types in PostgreSQL - DOMAINs and user-defined custom data types. Get some quick examples and learn which tools are recommended.
PostGIS Day 2022
Catch up on what’s happening in the open source geospatial world with an overview of the PostGIS Day 2022 talks and videos.
Postgres at Scale: Running Multiple PgBouncers
Connection pooling with pgBouncer is great. For some our customers with high transaction loads, we can run multiple PgBouncers. Read about running multiple connection poolers and how we approach scaling out this part of your infrastructure.
Data Loading in Postgres for Newbies
This post covers many ways to get data in Postgres including csv, json, backup files, foreign data wrappers, and generating data with queries. Examples include simple steps you can copy and reuse.
Crunchy Bridge Terraform Provider
Terraform brings IaC practices to our fully managed cloud service, Crunchy Bridge. Find out how to get started with our Terraform provider.
Partitioning with Native Postgres and pg_partman
Partitioning is a handy tool for managing size and performance as your database scales. Elizabeth offers a tutorial of native partitioning and pg_partman using a sample IoT dataset. This tutorial contains the sql and steps for you to try out partitioning yourself with Postgres.
Data To Go: Postgres Logical Replication
Logical replication means you can take your data wherever you need it - for reporting, analytics, or testing. This is a tutorial on the basics of setting up logical replication.
PostGIS For Newbies
Load some PostGIS data, import a shape file and publish a map to the web. Easy peasy lemon squeezy.
Postgres Constraints for Newbies
Examples of Postgres constraints using a schema and data requirements for a reservation system.
Postgres Indexes for Newbies
Samples of b-tree, GIN, and GIST indexes for Postgres beginners.
PostGIS Day 2021
Highlights from the 3rd annual PostGIS Day, hosted virtually November 18th, 2021.
.png)
Postgres is Out of Disk and How to Recover: The Dos and Don'ts
The ultimate goal for any unplanned database interruption is to reduce data loss. So the advice here is aimed at someone in a production situation prioritizing minimizing data loss.
12 min read.png)
Database Terminology Explained: Postgres High Availability and Disaster Recovery
What follows is a summary of conversations I've had with customers on how to think about key tenants of database management, high availability and disaster recovery.
