✅ Postgresql Archives

Postgres Index Methods: Things you need to know

By Lê Hoàng Tâm October 22, 2024All topics, Database, PostgreSQLDatabase, optimize performance, Postgresql

In PostgreSQL, different types of index methods are used to optimize query performance, especially for large datasets. These methods include B-tree, GiST, GIN, and BRIN, and each serves a specific…

How to prevent table lock when add/drop index in Postgres?

By Lê Hoàng Tâm October 21, 2024All topics, Architecture & Design, Database, PostgreSQLoptimize performance, Postgresql

The CONCURRENTLY option in PostgreSQL is used when creating or dropping indexes to avoid locking the entire table during the process. It's especially useful in production environments where you want…

A Deep Dive into Schema-Based Multi-Tenancy: Scaling, Maintenance, and Best Practices

By Lê Hoàng Tâm September 25, 2024All topics, Architecture & Design, Database, PostgreSQL, Ruby on RailsDatabase, Postgresql

Introduction As your application scales and serves multiple tenants, choosing the right multi-tenancy architecture is critical. One popular approach in the Rails ecosystem is schema-based multi-tenancy, particularly with PostgreSQL. In…

Understanding PostgreSQL WAL and How It Can Save Your Data

By Lê Hoàng Tâm September 12, 2024All topics, Database, PostgreSQLDatabase, Point in time recovery, Postgresql, WAK, WAL

PostgreSQL’s Write-Ahead Logging (WAL) system is a fundamental component that ensures database durability, data integrity, and the ability to recover from crashes. If you've ever wondered how PostgreSQL can help…

Shedding Some Light: How the DROP COLUMN Command Works in PostgreSQL

By Lê Hoàng Tâm April 18, 2024DatabaseDatabase, Postgresql, SQL

Imagine your PostgreSQL database as a filing cabinet. Over time, you might accumulate folders you no longer need. The DROP COLUMN command acts like a handy tool to declutter your…

Postgresql

Postgres Index Methods: Things you need to know

How to prevent table lock when add/drop index in Postgres?

A Deep Dive into Schema-Based Multi-Tenancy: Scaling, Maintenance, and Best Practices

Understanding PostgreSQL WAL and How It Can Save Your Data

Shedding Some Light: How the DROP COLUMN Command Works in PostgreSQL

Step-by-Step Guide: Setting Up Git and Shell Aliases on All Operating Systems

Laragon: The Ultimate Lightweight Development Environment for Windows

Github Action Interview: CICD Pipeline

LIKE vs Full-Text Search: SQL Performance and Use Cases