Insights on database performance, optimization strategies, and technical deep dives

Latest posts

Autonomous Software Maintenance Has Arrived

Autonomous Software Maintenance Has Arrived

Today is a significant milestone in Tembo's journey. We began as a managed Postgres service, and have evolved into an autonomous software maintenance company. It's a shift from managing database infrastructure to actively improving software. The new Tembo is a superhuman junior developer AI agent that maintains your software in a new way. This strategic pivot builds upon the success of our recent dba.ai experiment, and aligns with our vision for the future of software maintenance engineering.

Ry Walker and Sylvie O'Connor
Fix Slow Queries on AWS RDS + Aurora Postgres

Fix Slow Queries on AWS RDS + Aurora Postgres

Slow database queries can bottleneck your application performance and frustrate users. Learn how dba automates the process of identifying and fixing slow queries in AWS RDS and Aurora PostgreSQL environments, saving time and improving database performance.

Ry Walker and Sylvie O'Connor
Introducing dba: The Autonomous AI Agent For Postgres

Introducing dba: The Autonomous AI Agent For Postgres

dba was the first autonomous AI Agent that closes the gap between Postgres monitoring and software engineering. The experiment that was dba.ai is now tembo.io.

Ry Walker
Announcing Tembo Series A

Announcing Tembo Series A

Tembo has raised a $14M Series A round, to fuel our mission to make it as easy as possible for developers to more easily access the entire Postgres open source ecosystem.

Ry Walker
How to Get the Most out of Postgres Memory Settings

How to Get the Most out of Postgres Memory Settings

Learn how to optimize Postgres memory settings to maximize performance without risking OOM kills. Discover the best practices for configuring shared_buffers, work_mem, and maintenance_work_mem to get the most from your available RAM while preventing resource exhaustion.

shaun
Benchmarking PostgreSQL connection poolers: PgBouncer, PgCat and Supavisor

Benchmarking PostgreSQL connection poolers: PgBouncer, PgCat and Supavisor

Compare three popular PostgreSQL connection poolers - PgBouncer, PgCat, and Supavisor - with comprehensive benchmarks measuring throughput, latency, and CPU utilization. Discover which pooler performs best for different connection loads and get practical insights to help you choose the right one for your workloads.

rjzv
Introducing prometheus_fdw: Seamless Monitoring in Postgres

Introducing prometheus_fdw: Seamless Monitoring in Postgres

What you have: all your monitoring data and analytics stored over there in Prometheus. What you'd like to have: all of that data over here in your Postgres database.

Jay K
Vector Indexes in Postgres using pgvector: IVFFlat vs HNSW

Vector Indexes in Postgres using pgvector: IVFFlat vs HNSW

In databases, indexes are data structures that speed up finding specific values in a table column. The analogous task in vector databases consists of finding the (approximate) nearest-neighbors of a given vector. So, to accomplish this task fast, we can similarly create specialized vector indexes.

rjzv
Unleashing the power of vector embeddings with PostgreSQL

Unleashing the power of vector embeddings with PostgreSQL

Learn how to transform text into vectors for similarity search using pgvector, and build RAG (Retrieval-Augmented Generation) systems with PostgreSQL to enhance your AI applications with accurate, up-to-date information from your knowledge base.

rjzv
Unlocking value from your Clerk User Management platform with Postgres

Unlocking value from your Clerk User Management platform with Postgres

Postgres supports the concept of a Foreign Data Wrapper. Let's dive into what this is and how it can help us to access data from Clerk.

Jay K
Optimizing Postgres's Autovacuum for High-Churn Tables

Optimizing Postgres's Autovacuum for High-Churn Tables

Learn how to optimize Postgres autovacuum settings for high-churn tables to prevent table bloat, improve query performance, and increase transaction throughput. This hands-on guide explores how to tune scale factors, cost limits, and timing parameters with real benchmarks.

adam
Introducing pg_later: Asynchronous queries for Postgres, inspired by Snowflake

Introducing pg_later: Asynchronous queries for Postgres, inspired by Snowflake

We've released pg_later: a new Postgres extension that enables asynchronous query execution, inspired by Snowflake's async capabilities. Submit your queries to Postgres now, and come back later to get the results. Perfect for long-running maintenance jobs and analytical queries.

Adam
Introducing PGMQ: Simple Message Queues built on Postgres

Introducing PGMQ: Simple Message Queues built on Postgres

We've released PGMQ: a packaged extension for message queues on Postgres. Developers have been implementing queues on Postgres in many different ways and we're excited to combine lessons learned from those projects into a simple, feature-rich extension.

Adam
Tembo Manifesto

Tembo Manifesto

This is the original blog post announcing our Tembo Manifesto. We have since moved to focus on autonomous software maintenance, rather than a managed Postgres service.

Ry Walker
Introducing Tembo

Introducing Tembo

This is the original blog post announcing the launch of Tembo. We have since moved to focus on autonomous software maintenance, rather than a managed Postgres service.

Ry Walker