8 docs tagged with "postgres"

All common open-source relational database management systems are supported in all versions of Atlas.

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.

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.

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.

Learn how to create and manage indexes with included columns in PostgreSQL using Atlas. Understand the benefits of covering indexes and how to improve query performance.

Learn how to optimize disk space in PostgreSQL by arranging table columns in an efficient order to reduce padding space. Discover how Atlas CI for databases can help you determine the best order of columns for optimal data alignment.

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.

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