---
title: Postgres guides
summary: >-
  Covers the features of Postgres within the Neon environment, including data
  types, extensions, functions, and strategies for optimizing query performance.
enableTableOfContents: false
redirectFrom:
  - /docs/postgres/postgres-intro
updatedOn: '2026-02-06T22:07:33.125Z'
---

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](https://www.postgresql.org/docs/current/).

<DetailIconCards>

<a href="/docs/data-types/introduction" description="Learn about commonly-used Postgres data types" icon="database">Data types</a>

<a href="/docs/extensions/pg-extensions" description="Level up your database with our many supported Postgres extensions" icon="app-store">Extensions</a>

<a href="/docs/functions/introduction" description="Learn about commonly-used Postgres functions" icon="code">Functions</a>

<a href="/docs/postgresql/index-types" description="Optimize query performance with indexes in Postgres" icon="setup">Indexes</a>

<a href="/docs/postgresql/query-performance" description="Strategies for optimizing Postgres query performance" icon="performance">Query performance</a>

<a href="/docs/postgresql/query-reference" description="Find examples of commonly-used Postgres queries for basic to advanced operations" icon="research">Query reference</a>

<a href="/docs/reference/compatibility" description="Learn about Neon as a managed Postgres service" icon="puzzle">Compatibility</a>

<a href="/docs/postgresql/postgres-version-policy" description="Read about Neon's policy for Postgres version support and maintenance" icon="trend-up">Neon Postgres Version Support</a>

<a href="/docs/postgresql/postgres-upgrade" description="Learn how to upgrade your Postgres version in Neon" icon="trend-up">Upgrade Postgres</a>

</DetailIconCards>