Postgres guides

Explore Postgres features with Neon's Postgres guides. Learn about data types, extensions, functions, and optimizing query performance. Remember, Neon is Postgres, so you're encouraged to reference both the Neon documentation and the official PostgreSQL documentation.

• Data types

  Learn about commonly-used Postgres data types

• Extensions

  Level up your database with our many supported Postgres extensions

• Functions

  Learn about commonly-used Postgres functions

• Indexes

  Optimize query performance with indexes in Postgres

• Query performance

  Strategies for optimizing Postgres query performance

• Query reference

  Find examples of commonly-used Postgres queries for basic to advanced operations

• Compatibility

  Learn about Neon as a managed Postgres service

• Neon Postgres Version Support

  Read about Neon's policy for Postgres version support and maintenance

• Upgrade Postgres

  Learn how to upgrade your Postgres version in Neon