7 docs tagged with "postgres hcl schema"

Create descending indexes in PostgreSQL to optimize queries with an ORDER BY clause, and manage them in schema migrations with Atlas.

Index expression values with functional indexes in PostgreSQL to speed up queries, with syntax, examples, and how to manage them with Atlas.

Use operator classes in PostgreSQL indexes to optimize queries with specific operators, with syntax, examples, and how to manage them with Atlas.

Create indexes with included columns (covering indexes) in PostgreSQL to improve query performance, and manage them with Atlas.

Use partial indexes in PostgreSQL to improve performance and reduce storage costs, and manage them in schema migrations with Atlas.

aggregate

Learn how to create and manage serial columns in PostgreSQL, including changing column types and using Atlas for schema management.