Migrating from Postgres to CockroachDB: bulk loading performance

Published in

The Startup

8 min readMay 28, 2020

--

I started using CockroachDB about four months and its been really great, I love the product. Here is a story about how I recently migrated a large database (~400GB) from PostgreSQL over to CockroachDB. This blog is a recap of my process and also of some of the tricky parts I encountered.

Setup Details

Jessica G

Written by Jessica G

Writer for

The Startup

Live simply. Program stuff.

More from Jessica G and The Startup

Jessica G

Digging into Docker layers

While running a Docker container recently I wanted to view the contents of each layer that made up the image.

6 min readNov 13, 2016

--

four cartoonish images of a white woman in business wear. i like this image because it looks like 4 different social media profiles.

Zulie Rane
in
The Startup

If You Want to Be a Creator, Delete All (But Two) Social Media Platforms

In October 2022, during the whole Elon Musk debacle, I finally deleted Twitter from my phone. Around the same time, I also logged out of…

8 min readApr 19

--

Nitin Sharma
in
The Startup

Goodbye ChatGPT: Here Are (New) AI Tools That Will Blow Your Mind

I bet that 99% of the readers are not familiar with any of these tools.

6 min readApr 5

--

Jessica G

What is the difference between a process, a container, and a VM?

Many people ask “What is the difference between a VM and a container?”, but in my opinion a more interesting question is …

7 min readJan 19, 2019

--

See all from Jessica G

See all from The Startup

Recommended from Medium

Ecky Putrady
in
Dev Genius

PostgreSQL Index Best Practices

Foundation and best practices to set up the right indexes for your PostgreSQL database.

5 min readMar 25

--

Love Sharma
in
Dev Genius

System Design Blueprint: The Ultimate Guide

Developing a robust, scalable, and efficient system can be daunting. However, understanding the key concepts and components can make the…

9 min readApr 20

--

Lists

Staff Picks

323 stories81 saves

Stories to Help You Level-Up at Work

19 stories46 saves

Self-Improvement 101

20 stories92 saves

Productivity 101

20 stories95 saves

Aleksei Novikov
in
Dev Genius

Postgres 15 internals #3: Pages introduction and TOAST

This time we are going to talk about the way data is stored in files. What pages are and what is TOAST.

6 min readMar 10

--

Alexander Nguyen
in
Level Up Coding

Why I Keep Failing Candidates During Google Interviews…

They don’t meet the bar.

4 min readApr 13

--

Luís Oliveira
in
Level Up Coding

How to run PostgreSQL and pgAdmin with Docker

And an alternative with docker-compose

6 min readJan 9

--

Ecky Putrady
in
Better Programming

How to Interact With PostgreSQL From Rust Using SQLx

The important things you need to know to get the job done.

4 min readJan 23

--

See more recommendations

Help
Status
Writers
Blog
Careers
Privacy
Terms
About
Text to speech