Hashrocket.com / blog

Results for “PostgreSQL”

Small elephant show in chiang mai p1110469

Exploring the Postgres Gin index

Posted by Derek Parker in PostgreSQL

Postgres has 4 different types of indexes, each better suited for a particular task. In this post, I will explore the Postgres Gin index and how to...

Small large advisory locks

Advisory Locks in PostgreSQL

Posted by Derek Parker in PostgreSQL

PostgreSQL provides various lock modes to control concurrent access to data in tables. Advisory locks provide a convenient way to obtain a lock...