SQL query optimization: a comprehensive developer's guide

Ok you got a database, how do you optimize SQL performances? To answer this question you need a lot of time and effort in order to understand workloads and performance patterns, evaluate degradation a...

Postgresql Varlena Structure

Forwardpostgresql will have some variable-length data types, storage are using varlena format (except cstring type), through the statement SELECT typname FROM pg_type WHERE typlen = -1 you can see all...

When Postgres blocks: 7 tips for dealing with locks

This article describes 7 tips to avoid Postgres hanging: don't add columns with default values; beware of lock queues and use lock timeouts; create indexes in parallel; acquire high-level locks as...

Postgresql Checkpoint Principles

ForwardThe checkpoint of postgresql is a very important part of the database, it involves all aspects of database caching, persistence and data recovery. It involves a lot of disk IO during execution,...

Postgres Extension for pgvector: Vector Similarity Search

pgvector 是 Postgres 的扩展，能在其中存储和查询向量，与 Postgres 无缝集成。它有向量存储、相似性搜索、集成 SQL 支持等核心功能，支持多种向量类型和相似性度量标准。适用于推荐系统等场景，使用前需创建应用获...

Why Postgres SQL over MySQL for High Performance Scenarios

1.Introduction to the database1.1 MySQLMySQL claims to be the most popular open source database, and it is one of the most popular RDBMS (Relational Database Management System) applications.The M in L...