Prakhar Shukla
  • Home
  • About
  • Grafana
  • Proxmox
  • Proxmox-ARM
  • Code
  • Code-ARM
  • K8s
  • Status
Sign in

Database

A collection of 1 post
PostgreSQL Backups - COPY vs INSERT
Database

PostgreSQL Backups - COPY vs INSERT

I wrote some scripts to backup and restore the data of Postgres tables. And normally everything was fine initially with Inserts, but as the size of the table increases, the restore took much more longer than tolerable. For example, one local restore action of Home Assistant DB took approximately 4
03 Sep 2023 1 min read
Page 1 of 1
Prakhar Shukla © 2026
Powered by Ghost