Postgres best practices | Learn PostgreSQL | Tiger Data

Home Time series basics Postgres basics Postgres guides Postgres best practices Postgres extensions Postgres for real-time analytics

Database operations

Best Practices for PostgreSQL Database Operations

Data analysis

Best Practices for PostgreSQL Data Analysis

Data aggregation

Best Practices for PostgreSQL Aggregation

Database replication

Best Practices for Postgres Database Replication

Query optimization

How to Use a Common Table Expression (CTE) in SQL

Scaling postgres

Best Practices for Scaling PostgreSQL

Data management

How to Manage Your Data With Data Retention Policies How to Store Video in PostgreSQL Using BYTEA Best Practices for Postgres Data Management

Database design and modeling

How to Design Your PostgreSQL Database: Two Schema Examples How to Handle High-Cardinality Data in PostgreSQL How to Use PostgreSQL for Data Normalization

Performance

Best Practices for Postgres Performance Testing Postgres Ingest: INSERT vs. Batch INSERT vs. COPY

Database security

Best Practices for Postgres Security

Postgres best practices | Learn PostgreSQL | Tiger Data