Setting up logical replication with Postgres
Getting data out of your Postgres database and into a different data store, like BigQuery or Redshift, is easy with logical replication. This guide shows you how.
Showing posts tagged with postgres
Managing activity in a Postgres database
When applications reach a certain scale, the database quickly becomes a non-negotiable consideration. Strange issues start to appear when storing millions of records and processing thousands of transactions per second. This post offers a few quick pointers for addressing issues as they arise.
Efficiently backfilling data in Postgres
While a rake task or background job works fine for most data imports, they become prohibitively slow when dealing with millions of rows. PostgreSQL’s \copy command can handle these large datasets orders of magnitude faster than application-level approaches.