--- title: I replaced my entire stack with Postgres... | daily.dev description: PostgreSQL can replace a surprising number of specialized services in a typical tech stack. JSONB with GIN indexes handles NoSQL-style document storage, SELECT... canonical: https://daily.dev/posts/i-replaced-my-entire-stack-with-postgres--gtko21asj twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: I replaced my entire stack with Postgres... | daily.dev og:description: PostgreSQL can replace a surprising number of specialized services in a typical tech stack. JSONB with GIN indexes handles NoSQL-style document storage, SELECT... og:url: https://daily.dev/posts/i-replaced-my-entire-stack-with-postgres--gtko21asj og:image: https://api.daily.dev/og/posts/Gtko21aSj.png og:image:alt: I replaced my entire stack with Postgres... og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # I replaced my entire stack with Postgres... **[The Coding Gopher](https://daily.dev/sources/codinggopher)** · 10 min read · 183 upvotes · 10 comments ## Summary PostgreSQL can replace a surprising number of specialized services in a typical tech stack. JSONB with GIN indexes handles NoSQL-style document storage, SELECT FOR UPDATE SKIP LOCKED turns a table into a concurrent job queue, tsvector/tsquery plus pg_trgm power full-text and fuzzy search, and the pgvector extension with HNSW indexes enables vector similarity search alongside relational data. PostGIS covers geospatial queries, declarative partitioning with BRIN indexes handles time-series workloads, materialized views replace basic data warehouse dashboards, and tools like PostgREST or pg_graphql auto-generate APIs directly from the schema. The post acknowledges limits: horizontal sharding at extreme scale and sub-millisecond in-memory caching still warrant specialized tools, but for most applications PostgreSQL alone is a cost-effective, battle-tested foundation. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@sunyfilip** · 29 upvotes > yes...exactly as said for you and your mom....but in bigger apps you need to think about performance....once you have too huge bandwith you need possibility to scale your system...if you have everything in DB your maximum bandwith is limited by single db engine > > so yes, I also already using those principles in smaller apps but no, you don't want that in company with 100 000+ active users **@talhasiddique7** · 24 upvotes >  **@ezpie** · 13 upvotes > ok now enough with the replace your tech stack with PostgreSQL propaganda fellas. **@eugeneyaremenko** · 6 upvotes > Well TimescaleDB is a pg extension so you can slap it on eventually. And replacing Redis with Unlogged tables also makes sense. Interestingly replacing db with Redis also possible for many use cases but kinda locks you in since it's harder to migrate to "real" db. **@hanzo\_vnn** · 5 upvotes > I mean for small / self-project application, this approach seems perfect haha ## Similar posts on daily.dev - [Just Use Postgres](https://daily.dev/posts/just-use-postgres-ueffslq3a) · Lobsters · 0 upvotes · 0 comments - [Postgres Is Enough](https://daily.dev/posts/postgres-is-enough-sr1zzbbg9) · Lobsters · 83 upvotes · 10 comments - [It’s 2026, Just Use Postgres](https://daily.dev/posts/it-s-2026-just-use-postgres-qtm7zngdf) · Hacker News · 374 upvotes · 23 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#postgresql](https://daily.dev/tags/postgresql), [#microservices](https://daily.dev/tags/microservices), [#full-text-search](https://daily.dev/tags/full-text-search), [#pgvector](https://daily.dev/tags/pgvector) [View this post on daily.dev](https://daily.dev/posts/i-replaced-my-entire-stack-with-postgres--gtko21asj) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"I replaced my entire stack with Postgres...","url":"https://daily.dev/posts/i-replaced-my-entire-stack-with-postgres--gtko21asj","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/i-replaced-my-entire-stack-with-postgres--gtko21asj"},"datePublished":"2026-04-16T13:12:13.400Z","dateModified":"2026-04-16T13:12:31.975Z","description":"PostgreSQL can replace a surprising number of specialized services in a typical tech stack. JSONB with GIN indexes handles NoSQL-style document storage, SELECT...","image":"https://i.ytimg.com/vi/TdondBmyNXc/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/TdondBmyNXc/sddefault.jpg","isAccessibleForFree":true,"articleSection":"The Coding Gopher","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"The Coding Gopher","logo":"https://media.daily.dev/image/upload/s--pv2IKQMG--/f_auto/v1736753456/logos/codinggopher","url":"https://daily.dev/sources/codinggopher"},"commentCount":10,"discussionUrl":"https://daily.dev/posts/i-replaced-my-entire-stack-with-postgres--gtko21asj","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":183},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":10}],"keywords":"backend,postgresql,microservices,full-text-search,pgvector","timeRequired":"PT10M","video":{"@type":"VideoObject","name":"I replaced my entire stack with Postgres...","description":"PostgreSQL can replace a surprising number of specialized services in a typical tech stack. JSONB with GIN indexes handles NoSQL-style document storage, SELECT...","thumbnailUrl":"https://i.ytimg.com/vi/TdondBmyNXc/sddefault.jpg","uploadDate":"2026-04-16T13:12:13.400Z","duration":"PT10M","url":"https://api.daily.dev/r/Gtko21aSj","embedUrl":"https://www.youtube.com/embed/TdondBmyNXc"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"The Coding Gopher","item":"https://daily.dev/sources/codinggopher"},{"@type":"ListItem","position":3,"name":"I replaced my entire stack with Postgres..."}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/i-replaced-my-entire-stack-with-postgres--gtko21asj","comment":[{"@type":"Comment","text":"yes…exactly as said for you and your mom…but in bigger apps you need to think about performance…once you have too huge bandwith you need possibility to scale your system…if you have everything in DB your maximum bandwith is limited by single db engine\nso yes, I also already using those principles in smaller apps but no, you don’t want that in company with 100 000+ active users","datePublished":"2026-04-17T08:05:50.534Z","url":"https://daily.dev/posts/Gtko21aSj#c-qnQvQSqX9","author":{"@type":"Person","name":"Filip Januš","url":"https://daily.dev/sunyfilip","image":"https://lh3.googleusercontent.com/a/ACg8ocKAWfw1FGaQxjvEehprxNkdfgzHfwQJJW4g6qXZ0C9fkTpaZwQ=s96-c"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":29}},{"@type":"Comment","text":"","datePublished":"2026-04-17T05:07:09.468Z","url":"https://daily.dev/posts/Gtko21aSj#c-rNKcoTl91","author":{"@type":"Person","name":"Talha Siddique","url":"https://daily.dev/talhasiddique7","image":"https://media.daily.dev/image/upload/s--ICFWp8AE--/f_auto/v1776346634/avatars/avatar_6b53uw8lPdfVKdrwHcxDO?_a=BAMAMiWQ0"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":24}},{"@type":"Comment","text":"ok now enough with the replace your tech stack with PostgreSQL propaganda fellas.","datePublished":"2026-04-17T11:30:03.799Z","url":"https://daily.dev/posts/Gtko21aSj#c-niCEoy5tz","author":{"@type":"Person","name":"Ezpie","url":"https://daily.dev/ezpie","image":"https://avatars.githubusercontent.com/u/104765117?v=4"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":13}},{"@type":"Comment","text":"Well TimescaleDB is a pg extension so you can slap it on eventually. And replacing Redis with Unlogged tables also makes sense. Interestingly replacing db with Redis also possible for many use cases but kinda locks you in since it’s harder to migrate to “real” db.","datePublished":"2026-04-17T17:06:53.919Z","url":"https://daily.dev/posts/Gtko21aSj#c-xa1Mi4tV4","author":{"@type":"Person","name":"Eugene Yaremenko","url":"https://daily.dev/eugeneyaremenko","image":"https://avatars.githubusercontent.com/u/1898905?v=4"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":6}},{"@type":"Comment","text":"I mean for small / self-project application, this approach seems perfect haha","datePublished":"2026-04-20T03:34:58.646Z","url":"https://daily.dev/posts/Gtko21aSj#c-Ur9QYFDNa","author":{"@type":"Person","name":"Khiem Tran","url":"https://daily.dev/hanzo_vnn","image":"https://media.daily.dev/image/upload/s---BSD_rU5--/f_auto/v1769652892/avatars/avatar_rXCrqsfTiFKAASSdGFSMr?_a=BAMAMiiu0"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":5}}]} ```