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…

Understanding the Limits of LIMIT and OFFSET for Large Datasets

By Lê Hoàng Tâm October 17, 2024All topics, Database, MySQL, PostgreSQL

Introduction When dealing with large datasets (e.g., over 100 million records), using LIMIT and OFFSET for pagination can lead to significant performance problems. This post will explain how the algorithm…

Mastering Databases: From Optimizing Queries to Distributed Systems

By Hoài Nhớ October 17, 2024Database, MySQL, NoSQL, PostgreSQL, TipsBackup Database, Database Replica, Optimize Queries, Popular, Scalability Database

Databases are at the core of modern applications, from e-commerce to social platforms, powering billions of transactions every second. In this blog, we’ll explore key concepts that every software engineer…

Foreign Keys and Performance: Things You Might Not Know in RDBMS

By Lê Hoàng Tâm September 26, 2024All topics, Database, MySQL, PostgreSQL

A FOREIGN KEY in a relational database management system (RDBMS) is a constraint used to maintain referential integrity between two tables. The performance impact of using foreign keys can affect…

PostgreSQL

Postgres Index Methods: Things you need to know

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

Understanding the Limits of LIMIT and OFFSET for Large Datasets

Mastering Databases: From Optimizing Queries to Distributed Systems

Foreign Keys and Performance: Things You Might Not Know in RDBMS

The secret of console in javascript

Top 10 secrets of Ruby

Understanding Threads and Processes in Ruby: Optimize Performance on Multi-Core CPUs

What is Ruby’s Global Interpreter Lock (GIL) and How to Overcome Its Limitations?