“Best SQL database: it has a great ecosystem and excellent performance.”
DatabaseMaker says so +1 · source ↗
PostgreSQL
Open-source relational database with SQL, transactions, JSON and a large extension ecosystem (PostGIS, pgvector).
98 makers' products we track use PostgreSQL. For database it's 4th most chosen of 23 options: 98 of the 1,263 makers' products we know the database of (8%). Among the 397 launched in 2026, 1% chose it, against 7% of those launched in 2024 or earlier. 622 open-source projects also declare it in their code. What makers like most: It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. Their most common complaint: Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes. On GitHub, 116 public pull requests moved projects to PostgreSQL from tools we list, and 103 moved them away.
Profile checked
Works with AI agents:Built into ReplitHow makers use PostgreSQL
Makers' products we track use PostgreSQL for database (98), most often alongside Next.js (42%), Vercel (36%), Postmark (29%).
What PostgreSQL is used for
PostgreSQL vs the alternatives makers chose
For database, 98 of the 1,263 makers' products we know the choice of picked PostgreSQL (8%), behind Supabase (45%). Among those launched in 2026 it's 1%.
| Option | Makers' products | 2026 launches | Free for | At 10,000 users | Open source | |
|---|---|---|---|---|---|---|
| 573 45% | 63% | ~500 users | $25/mo · Pro | Yes | Compare → | |
| 187 15% | 9% | ~2,000 users | $9.66/mo · Blaze (pay as you go) | No | ||
| 128 10% | 5% | ~500 users | $58/mo · Atlas Dedicated M10 | No | Compare → | |
| 98 8% | 1% | — | — | Yes | ||
| 96 8% | 11% | None | $22/mo · Launch | Yes | Compare → | |
| 50 4% | 7% | ~630 users | $29/mo · Professional | Yes |
For database: how many of the 1,263 makers' products we know the database of chose each option, and the share among the 397 launched in 2026, since a tool that came first has products from every year, and what each costs at 10,000 users.
Costs are the cheapest plan that fits, from each vendor's pricing page, at the usage our stack planner assumes for a product with that many users. Free for: the users its cheapest plan a business can use stays free for.
Often paired with
Share of the 98 makers' products on PostgreSQL that show this choice.Markets that build with it most
Product Hunt markets where PostgreSQL is in far more of the stacks we know than across every market (1%).
When to use PostgreSQL, and when not
Pick PostgreSQL if
- You already run your own server and want a flat monthly cost. Database →
Something else fits better if
PostgreSQL is a relational database server: you define tables with types and constraints, query them with SQL, and it keeps data consistent through crashes and concurrent writes. It has been in development since 1986 at Berkeley and ACID-compliant since 2001.
More about PostgreSQL
The model to understand: one server process (the postmaster) listens for connections and starts a separate backend process for each client, which parses, plans and runs that client's queries. Clients talk to it over the PostgreSQL wire protocol, either through the C library libpq, which many language drivers wrap, or through independent implementations such as the Java JDBC driver.
What a small team gets in one database: all SQL-standard isolation levels including serializable, json and jsonb columns with indexing, built-in full-text search, many index types (GIN, GiST, BRIN and more), foreign data wrappers for querying other systems, and extensions such as PostGIS. Streaming replication keeps hot standbys in sync, and logical replication publishes changes table by table. It is free under a liberal license similar to BSD or MIT, and runs on all major operating systems.
Limits to know when running it yourself: each connection is a full server process, and the connection limit usually defaults to 100 and can only be changed by restarting the server. PostgreSQL does not include software that detects a failed primary and promotes a standby; that needs outside tools. Major-version upgrades need a dump and restore or pg_upgrade.
PostgreSQL pros and cons
What makers like most: It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. Their most common complaint: Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes.
Pros
- It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. PHPH 2PH 3PH 4
- With pgvector, embeddings live next to relational data, so AI features need no separate vector database. PHPH 2PH 3PH 4
- Extensions and features like PostGIS, JSON support and advanced indexing cover geospatial and semi-structured data too. PHPH 2PH 3
- Being open source and offered by dozens of hosts, it avoids lock-in, and pg_dump makes switching providers easy. PHPH 2PH 3PH 4
Cons and watch-outs
- Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes. HNHN 2
- It has no loose index scan, so SELECT DISTINCT over large tables needs manual workarounds. HNHN 2
- Timestamp versus timestamptz and AT TIME ZONE behavior are easy to get wrong, with edge-case bugs around daylight saving. HNHN 2HN 3
Themes that recur in makers' words and Hacker News comments, each linked to what it summarises, with how Product Hunt tags its reviews.
5.0★ from 77 reviews on Product Hunt ↗What Hacker News says about PostgreSQL
On Hacker News, 14% of comments about PostgreSQL recommend it and 3% criticize it: net praise +11%, 8th best liked of 16 tools HN discusses for database.
By year
| Year | Comments choosing it, per month | Net praise |
|---|---|---|
| 2023 | 73 | +22% |
| 2024 | 60 | +8% |
| 2025 | 55 | +8% |
| 2026 (8 mo) | 74 | +4% |
In their words
- “I’m very comfortable in Postgres and the setup cost is basically zero” HN, Aug 2026
- “100% Vanilla Postgres. We run upstream Postgres, no modifications.” HN, Apr 2026
- “Even with a proxy like PgDog the Postgres sharding story isn't solved.” HN, Jun 2026
Hacker News comments January 2023 to August 2026 that name PostgreSQL in a sentence like "I use" or "we moved to", Claude read a sample of 100 and the counts scale it to all of them; net praise is comments recommending it minus comments criticizing it, as a share of all comments about it. How it's counted, and how HN compares with makers.
Who switches
More projects move to PostgreSQL: 116 pull requests in, 103 out; the most come from MongoDB and leave for Neon.
MongoDB → PostgreSQL38 PRs
- refactor(db)!: migrate Payload CMS from MongoDB to Postgresm6-o4/payload-template-pg · 2026-09-25
- feat(db): move the data layer from MongoDB to Postgres with pgvectorjohnbekele/infracanvas · 2026-08-09
- fix: rewire merchant read path from MongoDB to Postgres, delete Merch…Syed-web-coder/expense-project · 2026-07-27
- Migrate storage from MongoDB to Postgres, hosting from Render to Vercelprashanth-ds-ml/workhub-office-time-tracker · 2026-07-13
- migrate ConnectionRequest feature from MongoDB to Postgres (Drizzle)Dikshant441/merge_me · 2026-07-08
- Database change from mongodb to postgresKrispymarty/CyberShield · 2026-06-22
- Migrate auth/school data layer from MongoDB to Postgres (Drizzle + Neon)Kayd-06/ACADEMIC-PLANNING-SYSTEM · 2026-06-22
- Switch subtraction reads from MongoDB to Postgresvirtool/virtool · 2026-06-05
- WIP: MongoDB to Postgres cutoverScarletbobcat/Nail-Art · 2026-05-25
- Ref/migarate from mongodb to postgresHosseinNamvar/bitex · 2026-05-24
Supabase → PostgreSQL27+ PRs
- Migrate from Supabase to self-hosted Postgres + Auth.jsynni-llan-energy/ynni-llan-energy · 2026-09-21
- BRAWUKA-507: staging app data moved off Supabase to Dokploy VPS Postgreslyuzizheng/coffeemode · 2026-09-20
- Migrate from Supabase to Railway Postgresbrawlstarsleon538/rabka-bloom-boutique · 2026-09-19
- Build the monitoring system and move off Supabase to Postgres, Prisma and Better Authtariq-khan9/webpulse · 2026-09-18
- Migrate from Supabase to Railway Postgresair-planes/3rd-bass · 2026-09-09
- Add Supabase bridge: mirror state to hosted Postgres for the Command Centerruslanjurakulov/nightshift-ai-studio · 2026-09-03
- Fix Supabase keepalive to use postgres.jsedgefour/EdgeFour-Value · 2026-08-27
- Add Supabase skills and switch EF to PostgresKristianEspevikUIA/StartProsjektMVC · 2026-08-26
- Migrate the database from Supabase to Vercel Postgres (Neon)sjoerdlier/11stedenlivetrack · 2026-08-18
- Switch production database config from Supabase to Prisma PostgresMillionaire-Mind/canopy-country-growth-os · 2026-08-17
Neon → PostgreSQL25 PRs
- fix(db): migrate off Neon (402 quota) to DO Managed PostgresCitrateNetwork/citrate-explorer · 2026-09-30
- Switch local DB setup from Neon to Docker Compose Postgreshenrilhos/compasso · 2026-09-21
- infra: migrate production database from Neon to Railway Postgreskayibabe/qwantej · 2026-09-19
- Switch DB client from Neon HTTP to postgres.js for Supabasedoommir/novapath-website · 2026-09-10
- Migrate database from Neon to self-hosted Postgres on k3sLeadKitchen/platform · 2026-09-04
- Migrate analytics DB from Neon to Railway Postgresckrohg/a2w-control · 2026-08-23
- docs(plan): move Postgres off Neon to Render Postgres (Plan 26)hh2110/thandkoi-clinics · 2026-08-17
- feat(db): move off the Neon driver to plain Postgresbeydemirfurkan/todox · 2026-08-15
- docs: rename Neon storage to Neon Postgresmastra-ai/mastra · 2026-08-11
- Revise why-neon.md to emphasize Lakebase Postgresneondatabase/website · 2026-07-31
Firebase → PostgreSQL12 PRs
- Migrate DB from NoSQL in firebase to Postgres in SupabaseDarshan-AS/postfolio · 2026-09-01
- Migrate from Firebase to Vercel Postgres for data syncrechefe/roiroi-trips-app · 2026-08-12
- Experiment/Firebase to Postgres migrationcioos-siooc/metadata-entry-form · 2026-07-06
- Bridge Firebase identity to the Postgres data layerEriclyfe2/GlobalBridge · 2026-06-02
- Migrate backend from Firebase to Postgres+DriveAssociation-of-Rajarata-ICT/arict-paper-portal · 2026-05-28
- Nick 6 migrate off firebase and google maps to postgres flutter mapJonKissil/Geocache · 2026-04-03
- 6 migrate off firebase and google maps to postgres flutter mapJonKissil/Geocache · 2026-04-02
- Nick 6 migrate off firebase and google maps to postgres flutter mapJonKissil/Geocache · 2026-03-31
- merge: migrate Firebase to Postgressand-worm-labs/sandworm-web · 2025-09-23
- Major refactor: Firebase to Postgres migration with complete setup flowbenmwilson/keepsakes · 2025-09-08
Turso → PostgreSQL6 PRs
- web: theme votes, page views and cookbook sales move from Turso to Postgresprofullstack/hqtui · 2026-09-25
- Move the waitlist from Turso to Postgresprofullstack/opensourcelegends.com · 2026-09-25
- Migrate from Turso to Postgres (happy path)tryy3/warera-tools · 2026-09-19
- Port DB from SQLite/Turso to Postgres on Neon (#96, #97, #98)zachradtka/nextopp · 2026-05-27
- Switch from Turso to Vercel Postgres (no extra signup)AlaudaAI/google-review-skill · 2026-02-16
- change vote from turso to Postgres test using filter by label = Milodatum-cloud/datum.net · 2025-06-18
PostgreSQL → Neon41 PRs
- Switch Phase 0 Postgres from Compose to Neonthomasnoe/fulfillment-exception-triage · 2026-09-19
- fix(render): move dev Postgres to external NeonMemoFlow/memoflow-api · 2026-09-14
- infra: move local Postgres to Neon, add staged startup for resource-c…pranav2004-bit/DECENTRALISED-SLOT-BOOKING-SYSTEM-USING-BECKN-PROTOCOLS · 2026-09-01
- feat(infra): cut Postgres over to Neon (CAL-152, Teams-only)caseyluna/hoop-brain · 2026-08-30
- Move production Postgres from Render free tier to Neonadab-tech/globalopportunities · 2026-08-25
- Port Postgres from Fly to Neonjeffko77/learn2drive · 2026-08-21
- Move DB hosting from Render Postgres to Neonconorlum/ValoMaths · 2026-08-17
- CI builds its own Postgres instead of talking to NeonDantheMan1991/superapp · 2026-08-15
- Move the database off Render's expiring free Postgres to Neon, and back it upradim-zhor/mini-ground-station · 2026-08-03
- feat(infra): migrate Postgres to Neon and object storage to Cloudflare R2AlaskanTuna/SolarSim · 2026-07-30
PostgreSQL → Supabase26+ PRs
- Database: plain Postgres driver, so the site can move to Supabasesalamituns/ng-gov-graph · 2026-10-02
- Media: move files from Postgres to Supabase StorageElAmir-Mansour/instagram-dm-automation · 2026-09-26
- ops: move Postgres from Railway to self-hosted Supabaseprofullstack/niche-db · 2026-09-23
- add Postgres schema via Flyway and connect to Supabasecs203-proj/cs203-project · 2026-09-22
- chore(deploy): move production Postgres from Render to SupabaseSiddharthP123/Project-3-Kelly-Poker-Simulator · 2026-09-13
- Migrate database from local Postgres to SupabaseHDAli00/MySaldo · 2026-09-03
- Move prod's Postgres from self-hosted CNPG to Supabaseyesid-lopez/homelab · 2026-08-24
- Migrate active n8n workflows from Postgres to Supabase nodeDenckerStudio/Folkets-meninger · 2026-08-23
- Migrate Postgres to Supabase (managed DB + Realtime)PeopleDrivenMusic/pdm · 2026-08-20
- Deploy Postgres schema to real Supabase project, fix RLS gaps found i…Raanank10/Medical-C5-System-For-SAR · 2026-08-19
PostgreSQL → MongoDB23 PRs
- feat: migrate NestJS persistence from Prisma/Postgres to MongoDB (Mongoose)Diatech226/Bikiengasite · 2026-09-30
- transparency-service: Postgres to MongoDB Atlasaimozart/entropa-public · 2026-09-28
- Switch backend storage from Postgres to MongoDB.Debarun1205/valmont-financial-group · 2026-09-25
- Change the db from postgres back to mongodbBOL-DEV/zentry-backend · 2026-09-16
- Codewithbasu postgres to mongodbCodeWithBasu/Life-RPG · 2026-09-13
- feat: migrate Prisma/Postgres backend to MongoDB (Prisma 6, ObjectId)Diatech226/Maryme-backend · 2026-09-06
- feat(db): migrate primary data store from Postgres to MongoDBByte-Quill/user-management-system · 2026-08-06
- Move hq from Postgres to MongoDBzoworkhq/zoblocks · 2026-08-06
- Move logs from Postgres to MongoDBMuhammetAli2828/Ops_center · 2026-07-21
- Migrate chocolate-store from Postgres to MongoDBaninamu/chocolate-store · 2026-07-13
PostgreSQL → Firebase6 PRs
- Migrate Zeiterfassung from Postgres to Firebase Firestoreteamtrack1019/AquaCon-Zeiterfassung · 2026-09-29
- Move the app from Python/Postgres to Firebasesmackmathew/psychic-telegram · 2026-09-26
- Migrate auth and result persistence from Neon/Postgres placeholders to FirebaseHallengren06/mattefysikprovet · 2026-06-22
- refactor: migrate backend persistence from Prisma/Postgres to Firebasefratellilenzi/prova · 2026-02-12
- feat(migration): migrate from NextAuth/Postgres to Firebase Auth/Fire…Okpeyemi/cohezi-comp · 2026-01-17
- Migrated from Postgres to firebase rtdb dominickdupuy/DHAM · 2025-11-30
PostgreSQL → Turso4 PRs
- Migrate Payload DB from Postgres to Turso SQLitehephatech/feelings.bar · 2026-07-29
- Migrate database from Netlify (Postgres) to Turso (SQLite)smkdwiguna/dwiguna-info · 2026-06-08
- feat(repo): migrate database from Neon Postgres to Turso (libSQL)johinsDev/loyalty-app · 2026-05-27
- 133 f migrates from postgres to tursoacmutsa/ClubKit · 2025-03-03
Public pull requests on GitHub since Oct 2024 whose title says "X to Y" — real code changes moving a project from one tool to another, by developers in general.
Who uses it
98 makers' products, each linked to the source that shows it, and 622 open-source projects that declare it in their code. The best known on Product Hunt: Scispace (3,114 followers), InsForge (2,302 followers), Lightfield (2,260 followers), Atlas.co (2,124 followers), Skarbe (2,082 followers). 1 of the makers' products is gone now (domain lapsed, up for sale or taken down); it chose PostgreSQL while live.
“At its core, Supabase is backed by Postgres, the gold standard for robust, reliable, and scalable databases.”
DatabaseMaker says so +1 · source ↗“Our primary database, offering strong consistency and robust transaction support.”
DatabaseMaker says so · source ↗“Listed in their tool stack on Starter Story”
DatabaseMaker says so · source ↗“The best relational database!”
DatabaseMaker says so · source ↗“Our tech stack combines React / React Native for the front, sitting on top of a Rails backend and a PostgreSQL database.”
DatabaseMaker says so · source ↗“Built on PostgreSQL. Prisma Postgres is our managed DB hosting for agents and TypeScript apps.”
DatabaseMaker says so · source ↗“Postgres is rock-solid and scales with us effortlessly. Its reliability and ecosystem make it a no-brainer over other databases.”
DatabaseMaker says so · source ↗“Reliable database storing memory data with full-stack integration for user management.”
DatabaseMaker says so · source ↗“Listed in their tool stack on Starter Story”
DatabaseMaker says so · source ↗“Absolutely love it - so easy and awesome!”
DatabaseMaker says so · source ↗“PGVector's native vector operations with PostgreSQL's ACID compliance works perfectly. We're storing millions of embeddings with sub-millisecond similarity search using cosine distance. The async connection pooling handles concurrent connections, while the vector indexing makes our query super fast. Having vector search, full-text search, and relational data in one database eliminates the complexity of managing multiple data stores.”
DatabaseMaker says so · source ↗“Database for all your commerce data.”
DatabaseMaker says so · source ↗“PostgreSQL gives us the best balance between well-structured data persistency and clean code principles”
DatabaseMaker says so · source ↗“Great solution for a SQL database. Our first choice.”
DatabaseMaker says so · source ↗“Superexpert.AI uses this database -- used the pgvector extension to support vector embeddings in the database.”
DatabaseMaker says so · source ↗“Postgres is rock-solid. It handles complex data relationships gracefully and gives us the querying power we need as we scale. For relational data, it’s hands down the best choice for us.”
DatabaseMaker says so · source ↗“Powerful database for handle our huge traffic”
DatabaseMaker says so · source ↗“PostgreSQL is our go-to database because of its reliability, scalability, and powerful support for structured data, making it ideal for managing and syncing customer data across multiple platforms.”
DatabaseMaker says so · source ↗“The GOAT open-source database.”
DatabaseMaker says so · source ↗“PostgreSQL serves as our primary database, offering powerful SQL querying and reliable data storage for managing structured data and transactions.”
DatabaseMaker says so · source ↗“ergonomic - easy to self-host, but also super easy to scale up to millions of users”
DatabaseMaker says so · source ↗“Offered a robust, scalable database for structured data storage and querying.”
DatabaseMaker says so · source ↗“Robust, scalable, and rock-solid database 🤘”
DatabaseMaker says so · source ↗“The best relational database out there. Loved by developers worldwide.”
DatabaseMaker says so · source ↗“Postgres was the second database we added, and honestly, it needs no introduction. This OSS RDBMS is massive, reliable, and just incredible to work with.”
DatabaseMaker says so · source ↗“pgvector is easy to use, and generally postgres is super easy to setup and run, especially with supabase!”
DatabaseMaker says so · source ↗“PostgreSQL is indispensable, housing our vast repository of 300 million papers totaling terabytes of data.”
DatabaseMaker says so · source ↗“We picked PostgreSQL over MongoDB and dedicated vector databases because one proven database handles our relational data, JSON and agent memory, with no extra stores to run.”
DatabaseMaker says so · source ↗“I run pgMustard , which is an online tool for developers that helps them troubleshoot slow PostgreSQL queries.”
DatabaseMaker says so · source ↗“Listed in their tool stack on Starter Story”
DatabaseMaker says so · source ↗“Google Workspace Discord GitHub AWS PostgreSQL REdis InfluxDB Python Flask …”
DatabaseMaker says so · source ↗“Postgres is so nice to work with. pg_dump was a lifesaver when we had to move database providers. Extensions like pgvector make it the best database for building AI apps.”
DatabaseMaker says so · source ↗“Powers everything in Router.so and makes it easy to set up an open source instance.”
DatabaseMaker says so · source ↗“OS, reliability and performance!”
DatabaseMaker says so · source ↗“Postgres stands out thanks to its rock‑solid reliability and rich feature set—think advanced indexing, robust JSON support, and strong concurrency. It’s open source, highly scalable, and keeps our data queries speedy without locking us into proprietary models. Alternatives Considered: MySQL: Popular, but we preferred Postgres’s deeper JSON and indexing capabilities. MongoDB: Excellent for flexible schemas, but we needed the reliability of SQL. MariaDB: Similar to MySQL, but Postgres’s community and extension ecosystem won us over.”
DatabaseMaker says so · source ↗“Sits at the heart of the VizDiff backend”
DatabaseMaker says so · source ↗“A powerful database that enables advanced geospatial analysis”
DatabaseMaker says so · source ↗“Starting with my preferred editor vs-code to full-fledged SQL databases like PostgreSQL , none of these cutting-edge applications cost anything.”
DatabaseMaker says so · source ↗“PostgreSQL reliability and scalability mean that as Hook0 grows, PGSQL grows with us, ensuring that your data is always safe, secure, and accessible in real-time”
DatabaseMaker says so · source ↗“Postgres is the backbone of our data layer. Rock-solid, feature-rich, and endlessly reliable, it let us scale with confidence while keeping queries elegant and our data safe.”
DatabaseMaker says so · source ↗“Rock-solid open source database that handles complex queries and high loads while maintaining data integrity. Production-ready and battle-tested.”
DatabaseMaker says so · source ↗“StatusSight uses PostgreSQL to store and analyze health data for thousands of services and APIs. We chose it since it's performant, powerful, and well-documented.”
DatabaseMaker says so · source ↗None of these in makers' own words.
Open source: a project that declares PostgreSQL as a dependency in its public code — verifiable, but not necessarily a live product.
What its projects tell coding agents
What open-source projects' AGENTS.md and CLAUDE.md files say about PostgreSQL, in our words — from the 82 files that name it:
Named as the project's main relational database, often alongside Redis.19 files
Cap-go/capgo.appChatbotXIO/ChatbotXPackmindHub/packmindRoznoshchik/LurnbyShelf-nu/shelf.nuUllrAI/SaaS-Starteraipotheosis-labs/acibaserow/baserowbenadida/helios-servercalcom/cal.diygiselles-ai/gisellellm-ring/lmringmattogodoy/nametagohcnetwork/careonyx-dot-app/onyx-fossopen-condo-software/condoopf/openprojectxang1234/stock-screenerzentralopensource/zentralPair PostgreSQL with Drizzle as the ORM and schema layer.11 files
Use the pgvector extension for embeddings and vector search inside PostgreSQL.8 files
Keep code portable across PostgreSQL and the other supported engines such as SQLite or MySQL.5 files
Run database tests against a real PostgreSQL instance rather than mocks or SQLite stand-ins.4 files
266 of the 422 open-source products built with PostgreSQL that were worked on in the last 180 days keep instruction files for coding agents — 63%, against 53% of all the projects we read. AGENTS.md is in 212, CLAUDE.md in 161.
Alternatives to PostgreSQL
All alternatives by situation →Further reading
Questions makers ask about PostgreSQL
Is PostgreSQL good for production?
98 makers' products we track run on it, and 1 of them have since gone (the product, not necessarily because of PostgreSQL). On GitHub, 116 public pull requests moved projects to PostgreSQL from tools we list, and 103 moved them away. The watch-out makers raise most: Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes.
What is PostgreSQL used for?
Open-source relational database with SQL, transactions, JSON and a large extension ecosystem (PostGIS, pgvector). Makers' products we track use it for database (98).
What are the pros and cons of PostgreSQL?
Pros makers name: It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. With pgvector, embeddings live next to relational data, so AI features need no separate vector database. Extensions and features like PostGIS, JSON support and advanced indexing cover geospatial and semi-structured data too. Cons: Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes. It has no loose index scan, so SELECT DISTINCT over large tables needs manual workarounds. Timestamp versus timestamptz and AT TIME ZONE behavior are easy to get wrong, with edge-case bugs around daylight saving.
What are the alternatives to PostgreSQL?
For database, the other options makers' products we track chose most are Supabase (573), Firebase (187), MongoDB (128), Neon (96), Convex (50). Open source or self-hostable among them: Supabase, MongoDB, Neon, Convex. Each alternative, with the situation it fits, is on the PostgreSQL alternatives page.
Is PostgreSQL still popular with new products?
Less than before: among the 397 makers' products launched in 2026 that made the database choice, 1% chose PostgreSQL, against 7% of the 335 launched in 2024 or earlier.
Do developers switch to or away from PostgreSQL?
On GitHub, 116 public pull requests moved projects to PostgreSQL from tools we list, most from MongoDB (38), Supabase (27), Neon (25); 103 moved them away, most to Neon (41), Supabase (26), MongoDB (23).
When should you use PostgreSQL?
You already run your own server and want a flat monthly cost (database). Something else fits better if: you want the database, auth and file storage in one project, and plain SQL you can take elsewhere, pick Supabase; you're building a live, collaborative app entirely in TypeScript, pick Convex.
How long is each version supported?
A new major version comes out about once a year, and each major version is supported for five years. Minor releases with bug and security fixes ship at least every three months. source ↗
How do I upgrade to a new major version?
Major versions change the on-disk format of system tables, so you either dump and reload, or use pg_upgrade, which reuses the existing data files and avoids a full dump and restore. Minor upgrades only need new binaries and a restart. source ↗
Can PostgreSQL store JSON?
Yes. There are two types, json, which keeps the exact input text, and jsonb, which stores a decomposed binary form that is faster to process and can be indexed. A jsonpath type supports queries into documents. source ↗
Does it have built-in full-text search?
Yes. Full-text search finds natural-language documents matching a query and can rank them by relevance, going well beyond LIKE and regex operators. source ↗
How many connections can it handle?
max_connections usually defaults to 100 and can only be changed at server start; raising it increases shared memory and other resources, because every connection gets its own backend process. source ↗
Does PostgreSQL fail over automatically?
Not on its own. It can keep warm or hot standbys current through WAL shipping or streaming replication, but it does not provide the software that detects a failed primary and promotes a standby; external tools do that. source ↗
Can I replicate only some tables to another database?
Yes. Logical replication uses a publish and subscribe model, replicating chosen tables and their changes by primary key, and subscribers can re-publish for cascading setups. source ↗
Is PostgreSQL free?
Yes — it is free, open-source software.
Is PostgreSQL open source or self-hostable?
Open source, and you can self-host it. source ↗
Can AI coding agents work with PostgreSQL?
Replit set it up natively.
Who uses PostgreSQL?
98 makers' products we track, each with a source, and 622 open-source projects declare it in their code. The best known of them on Product Hunt: Scispace (3,114 followers), InsForge (2,302 followers), Lightfield (2,260 followers), Atlas.co (2,124 followers), Skarbe (2,082 followers). source ↗