Skip to main content

7 docs tagged with "postgres hcl schema"

View all tags

Descending Indexes in PostgreSQL

Learn how to create and use descending indexes in PostgreSQL to optimize queries with the ORDER BY clause, and how to manage them in schema migrations using Atlas.

Functional Indexes in PostgreSQL

Learn how to use functional indexes in PostgreSQL to optimize query performance by indexing expression values. This guide covers syntax, examples, and how to manage them in schema migrations with Atlas.

Index operator classes in PostgreSQL

Learn how to use operator classes in PostgreSQL indexes to optimize query performance with specific operators and clauses. This guide covers the syntax, examples, and how to manage operator classes in schema migrations using Atlas.

Partial Indexes in PostgreSQL

Learn how to use partial indexes in PostgreSQL to improve performance and reduce storage costs, and how to manage them in database schema migration easily with Atlas.