Postgres Developer Hub
The Postgres Developer Hub is where we keep our guides, tutorials, and reference material for running Postgres, organized by topic. Some of it is about Postgres in general, and some of it is specific to Snowflake Postgres.
Postgres is the most popular open source relational database, and it runs everything from side projects to Fortune 500 systems. Snowflake Postgres is fully managed Postgres with high availability, automated backups, and a direct path to Snowflake for analytics and AI.
About Postgres
What Postgres is, why teams pick it, and how it works under the hood.
- What is Postgres?: history, capabilities, and how Postgres compares to other databases
- Why Postgres?: the case for Postgres on your next project
- psql Basics: get productive with the Postgres command-line client
- Postgres Architecture: processes, memory, storage, and the query lifecycle
Postgres Operations
Running Postgres reliably at scale: replication, backups, monitoring, tuning, and more.
- Replication: streaming replication, logical replication, and failover
- WAL (Write-Ahead Log): how Postgres guarantees durability and makes replication possible
- Vacuum: MVCC cleanup, autovacuum tuning, and keeping bloat in check
- Backups: pg_dump, pg_basebackup, PITR, and backup strategies
- Monitoring & Observability: metrics, alerting, and query performance analysis
- High Availability: failover, Patroni, and minimizing downtime
- Scaling: connection pooling, read replicas, partitioning, and sharding
- Connection Management: PgBouncer, pgpool, and the connection lifecycle
- Performance Optimization: query tuning, EXPLAIN, and configuration
- Indexing: B-tree, GIN, GiST, BRIN, and index maintenance
- Partitioning: range, list, and hash partitioning for large tables
- Upgrades & Version Management: major version upgrades and pg_upgrade
- AI in Postgres: pgvector, embeddings, and vector search
- Extensions: PostGIS, pg_partman, pg_stat_statements, and the rest of the extension ecosystem
- pg_lake: read and write Iceberg and files in object storage from Postgres, and share that data with Snowflake
Snowflake Postgres
Snowflake Postgres is a fully managed Postgres service that runs inside the Snowflake platform. You get standard Postgres without having to run the servers yourself.
- Getting Started: create your first Snowflake Postgres instance
- Migrating to Snowflake Postgres: move existing workloads with minimal downtime
- Cortex AI Integration: use Snowflake Cortex AI with your Postgres data
- Streamlit Apps: build data apps on top of your Postgres data
Learn Postgres
Interactive tutorials and hands-on guides, from your first SELECT to window functions and performance analysis.
- Learn Postgres: a Postgres sandbox that runs in your browser
Get Started
Want to try Postgres on Snowflake? Start here:
- Create a Snowflake Postgres instance. It takes a few minutes.
- Connect with psql, the standard Postgres CLI.
- Explore pg_lake to get your Postgres data into Snowflake for analytics.
This content is provided as is, and is not maintained on an ongoing basis. It may be out of date with current Snowflake instances
