UPDATE July 2023: What could be better in PostgreSQL? Find out about its weak points, and see what has improved since 2020.

How to deal with PostgreSQL restarts? pg_prewarm allows you to automatically prewarm your caches after a database failure or a simple restart

HOT updates (Heap Only Tuple) boost PostgreSQL DML performance. This article explains the concept, shows examples and gives tuning advice.

<div><img src="/assets/thumbnails/20220106-explain-analyze-needs-buffers-to-improve-postgres-query-optimization-process.jpeg" alt="Io, a Jupiter's moon"/> <small>(Io, a Jupiter's moon)</small></div> <p>SQL query optimization is challenging for those who have…

Artificial intelligence, machine learning, and deep learning are intertwined capabilities that attempt to solve problems that defy traditional computational solutions — problems include fraud detection, voice recognition, and search result recommendations.…

Video with transcript included on InfoQ: https://bit.ly/4aUrHmo

Montana Low provides an understanding of how Postgres can be used as a vector database for AI and how it can be integrated into your existing application stack.

#MachineLearning #PostgresML…

In this video, you'll learn how AI can make database queries easier. We show how to use Ollama’s AI model to create and run SQL queries on PostgreSQL automatically. AI helps speed up complex tasks, making data retrieval faster and more efficient. Watch and…

Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bit.ly/bytebytegoytTopic

Animation tools: Adobe Illustrator and After Effects.

Checkout our bestselling System Design Interview books:
Volume 1: https://amzn.to/3Ou7gkd…

Meet pgai and pgvectorscale, two new open-source extensions that make PostgreSQL even better for AI applications.

[pgvector](https://github.com/pgvector/pgvector/), an open-source PostgreSQL extension that provides vector similarity search capabilities, has released [v0.7.0](https://github.com/pgvector/pgvector/releases/tag/v0.7.0). This new release includes many new…

Open-source vector similarity search for Postgres. Contribute to pgvector/pgvector development by creating an account on GitHub.