What Is Temporal Data?
Do You Have Time-Series Data?
Is Your Data Time Series? The Types of Data Supported by PostgreSQL and Timescale
What Is PostgreSQL and Where Did It Come From
Data Partitioning: What It Is and Why It Matters
What Is Data Compression and How Does It Work?
What Is Dynamic PostgreSQL?
Self-Hosted or Cloud Database? A Countryside Reflection on Infrastructure Choices
Building a Scalable Database
PostgreSQL Joins : A Summary
What Is a PostgreSQL Full Outer Join?
What Is a PostgreSQL Cross Join?
What Is a PostgreSQL Inner Join?
What Is a PostgreSQL Left Join? And a Right Join?
PostgreSQL Join Type Theory
Understanding PostgreSQL Functions
PostgreSQL Mathematical Functions: Enhancing Coding Efficiency
Using PostgreSQL String Functions for Improved Data Analysis
Data Processing With PostgreSQL Window Functions
Powering Data Analysis With PostgreSQL Aggregate Functions
Understanding PostgreSQL Date and Time Functions
Understanding PostgreSQL SELECT
Postgres string_agg Function: A Quick Guide
Understanding PostgreSQL WITHIN GROUP
Understanding ACID Compliance
Vector Search vs Semantic Search
How to Use a Common Table Expression (CTE) in SQL
Understanding FILTER in PostgreSQL (With Examples)
Understanding the Postgres extract() Function
Understanding percentile_cont() and percentile_disc() in PostgreSQL
Understanding the rank() and dense_rank() Functions in PostgreSQL
Guide to PostgreSQL Performance
PostgreSQL Performance Tuning: Designing and Implementing Your Database Schema
PostgreSQL Performance Tuning: How to Size Your Database
PostgreSQL Performance Tuning: Key Parameters
PostgreSQL Performance Tuning: Optimizing Database Indexes
How to Reduce Bloat in Large PostgreSQL Tables
Determining the Optimal Postgres Partition Size
Is Postgres Partitioning Really That Hard? An Introduction To Hypertables
Pg_partman vs. Hypertables for Postgres Partitioning
Navigating Growing PostgreSQL Tables With Partitioning (and More)
Real-time Analytics in Postgres: Why It's Hard (and How to Solve It)
When to Consider Postgres Partitioning
An Intro to Database Indexes in Postgres
An Intro to Data Modeling on PostgreSQL
Designing Your Database Schema: Wide vs. Narrow Postgres Tables
Best Practices for Time-Series Data Modeling: Single or Multiple Partitioned Table(s) a.k.a. Hypertables
Best Practices for (Time-)Series Metadata Tables
Unlocking Better Database Monitoring in PostgreSQL
What Is a PostgreSQL Temporary View?
PostgreSQL Materialized Views and Where to Find Them
A PostgreSQL Database Replication Guide
Understanding PostgreSQL Tablespaces
Guide to Postgres Data Management
How to Compute Standard Deviation With PostgreSQL
A Guide to Data Analysis on PostgreSQL
How PostgreSQL Data Aggregation Works
How to Use Psycopg2: The PostgreSQL Adapter for Python
A Guide to Scaling PostgreSQL
How to Work With Time Series in Python?
Tools for Working With Time-Series Analysis in Python
Do More on AWS With Timescale: Build an Application Using Lambda Functions in Python
A Guide to pg_restore (and pg_restore Example)
Guide to PostgreSQL Security
5 Ways to Monitor Your PostgreSQL Database
Guide to PostgreSQL Database Operations
Best Practices for Postgres Performance
How to Design Your PostgreSQL Database: Two Schema Examples
Best Practices for PostgreSQL Database Operations
How to Manage Your Data With Data Retention Policies
Building Python Apps With PostgreSQL: A Developer's Guide
Best Practices for PostgreSQL Aggregation
Best Practices for Postgres Security
Best Practices for Scaling PostgreSQL
Best Practices for Postgres Data Management
Best Practices for Postgres Database Replication
PostgreSQL Extensions: amcheck
PostgreSQL Extensions: Unlocking Multidimensional Points With Cube
PostgreSQL Extensions: hstore
PostgreSQL Extensions: ltree
PostgreSQL Extensions: Secure Your Time-Series Data With pgcrypto
PostgreSQL Extensions: pg_prewarm
PostgreSQL Extensions: pgRouting
PostgreSQL Extensions: pg_stat_statements
PostgreSQL Extensions: Database Testing With pgTAP
PostgreSQL Extensions: Install pg_trgm for Data Matching
PostgreSQL Extensions: Turning PostgreSQL Into a Vector Database With pgvector
PostgreSQL Extensions: PL/pgSQL
PostgreSQL Extensions: Using PostGIS and Timescale for Advanced Geospatial Insights
Beyond the Basics: Exploring PostgreSQL Extensions
PostgreSQL Extensions: Intro to uuid-ossp
Timescale vs. Amazon RDS PostgreSQL: Up to 350x Faster Queries, 44 % Faster Ingest, 95 % Storage Savings for Time-Series Data
TimescaleDB vs. Amazon Timestream: 6,000x Higher Inserts, 5-175x Faster Queries, 150-220x Cheaper
How to Store Time-Series Data in MongoDB and Why That’s a Bad Idea
What Is ClickHouse and How Does It Compare to PostgreSQL and TimescaleDB for Time Series?
PostgreSQL + TimescaleDB: 1,000x Faster Queries, 90 % Data Compression, and Much More
What We Learned From Benchmarking Amazon Aurora PostgreSQL Serverless
Restore
Restore from backup file (.sql)
$ psql -U username -f filename.sql
// Restore database plain-text backup(.sql) generated by pg_dump or pg_dumpall with psql utility (psql)
Restore from custom archive backup file (.bak)
$ pg_restore -d db_name /path/to/your/file/db_name.bak -c -U db_user
// Restore database custom archive backup(.bak) using pg_restore utility (pg_restore)
pgBackrest is an awesome tool for backup creation/restore in Postgres, but it can get slow for large databases. Learn how we made Postgres backups 100x faster using EBS shapshots and pgBackrest.