Code Snippets

These are a collection of code snippets I've used in the past and saved. Some are for Rails, some marketing related, and all include setup instructions.

Postgres VACUUM FULL without a lock

How to simulate a VACUUM FULL on your Postgres database without locking it down.

Two-way database syncing in Rails 6.1

Example concern for syncing one DB to another with production traffic.

Postgres autovacuum scale factor

Few notes on keep Postgres autovacuum behaving nicely as you grow.