-
first chapter summary
Resources
customers also reading
This book
1°
2°
3°
All the database you need
- November 2025
- ISBN 9781633435698
- 400 pages
- printed in black & white
- available in Korean, Russian
print book available Nov 24, 2025
ePub + liveBook available Nov 24, 2025
pro 24ドル.99 per month
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose one free eBook per month to keep
- exclusive 50% discount on all purchases
- renews monthly, pause or cancel renewal anytime
lite 19ドル.99 per month
- access to all Manning books, including MEAPs!
team
5, 10 or 20 seats+ for your team - learn more
eBook
pdf, ePub, online
47ドル.99
35ドル.99
you save $12.00 (25%)
print
includes eBook
59ドル.99
44ドル.99
you save $15.00 (25%)
with subscription
free or 50% off
24ドル.99
pro 24ドル.99 per month
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose one free eBook per month to keep
- exclusive 50% discount on all purchases
- renews monthly, pause or cancel renewal anytime
lite 19ドル.99 per month
- access to all Manning books, including MEAPs!
team
5, 10 or 20 seats+ for your team - learn more
eBook
47ドル.99
35ドル.99
you save $12.00 (25%)
print
59ドル.99
44ドル.99
you save $15.00 (25%)
with subscription
24ドル.99
Look inside
You probably don’t need a collection of specialty databases. Just use Postgres instead!
Written for application developers and database pros, Just Use Postgres! shows you how to get the most out of the powerful Postgres database.
In Just Use Postgres! you’ll learn how to:
Over the decades, PostgreSQL, aka Postgres, has grown into the most powerful general-purpose database and has become the de facto standard for developers worldwide. Just Use Postgres! takes a modern look at Postgres, exploring the database’s most up-to-date features for AI, time-series, full-text search, geospatial, and other application workloads.
Written for application developers and database pros, Just Use Postgres! shows you how to get the most out of the powerful Postgres database.
In Just Use Postgres! you’ll learn how to:
- Use Postgres as an RDBMS for transactional workloads
- Develop generative AI, geospatial, and time-series applications
- Take advantage of modern SQL including window functions and CTEs
- Perform full-text search and process JSON documents
- Use Postgres as a message queue
- Optimize performance with various index types including B-trees, GIN, GiST, HNSW, and more
Over the decades, PostgreSQL, aka Postgres, has grown into the most powerful general-purpose database and has become the de facto standard for developers worldwide. Just Use Postgres! takes a modern look at Postgres, exploring the database’s most up-to-date features for AI, time-series, full-text search, geospatial, and other application workloads.
about the technology
You know that PostgreSQL is a fast, reliable, SQL compliant RDBMS. You may not know that it’s also great for geospatial systems, time series, full-text search, JSON documents, AI vector embeddings, and many other specialty database functions. For almost any data task you can imagine, you can use Postgres.about the book
Just Use Postgres! covers recipes for using Postgres in dozens of applications normally reserved for single-purpose databases. Written for busy application developers, each chapter explores a different use case illuminating the breadth and depth of Postgres’s capabilities. Along the way, you’ll also meet an incredible ecosystem of Postgres extensions like pgvector, PostGIS, pgmq, and TimescaleDB. You’ll be amazed at everything you can accomplish with Postgres!what's inside
- Generative AI, geospatial, and time-series applications
- Modern SQL including window functions and CTEs
- Full-text search and JSON
- B-trees, GIN, GiST, HNSW, and more
about the reader
For application developers, software engineers, and architects who know the basics of SQL.about the author
Denis Magda is a recognized Postgres expert and software engineer who worked on Java at Sun Microsystems and Oracle before focusing on databases and large-scale distributed systems.eBook
pdf, ePub, online
47ドル.99
35ドル.99
you save $12.00 (25%)
print
includes eBook
59ドル.99
44ドル.99
you save $15.00 (25%)
with subscription
free or 50% off
24ドル.99
pro 24ドル.99 per month
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose one free eBook per month to keep
- exclusive 50% discount on all purchases
- renews monthly, pause or cancel renewal anytime
lite 19ドル.99 per month
- access to all Manning books, including MEAPs!
team
5, 10 or 20 seats+ for your team - learn more
eBook
47ドル.99
35ドル.99
you save $12.00 (25%)
print
59ドル.99
44ドル.99
you save $15.00 (25%)
with subscription
24ドル.99
I was pleasantly surprised to learn many new things from this book.
An excellent guide covering everything from basics to cutting-edge features.
Pleasant, easy to read with tonnes of great code.
Well-organized and easy to search.
The missing guide to understanding and using Postgres.
related titles
related titles
choose your plan
pro
monthly
annual
24ドル.99
249ドル.99
only 20ドル.83 per month
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose another free product every time you renew
- choose twelve free products per year
- exclusive 50% discount on all purchases
- renews monthly, pause or cancel renewal anytime
- renews annually, pause or cancel renewal anytime
- Just Use Postgres! ebook for free
team
monthly
annual
49ドル.99
399ドル.99
only 33ドル.33 per month
- five seats for your team
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose another free product every time you renew
- choose twelve free products per year
- exclusive 50% discount on all purchases
- renews monthly, pause or cancel renewal anytime
- renews annually, pause or cancel renewal anytime
- Just Use Postgres! ebook for free
choose your plan
pro
monthly
annual
24ドル.99
249ドル.99
only 20ドル.83 per month
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose another free product every time you renew
- choose twelve free products per year
- exclusive 50% discount on all purchases
- renews monthly, pause or cancel renewal anytime
- renews annually, pause or cancel renewal anytime
- Just Use Postgres! ebook for free
team
monthly
annual
49ドル.99
399ドル.99
only 33ドル.33 per month
- five seats for your team
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose another free product every time you renew
- choose twelve free products per year
- exclusive 50% discount on all purchases
- renews monthly, pause or cancel renewal anytime
- renews annually, pause or cancel renewal anytime
- Just Use Postgres! ebook for free
Check your email for instructions on downloading Just Use Postgres!.