AI

Understanding DiskANN

19 Nov 2024 10 min read

DiskANN is a nearest neighbor search algorithm designed to minimize computing costs. Learn how it works, its advantages, and applications.

PostgreSQL, Blog

Scale PostgreSQL via Partitioning: A Dev’s Intro to Hypertables

18 Nov 2024 7 min read

PostgreSQL partitioning can be faster and more efficient. Get started quickly with hypertables in this step-by-step developer guide.

PostgreSQL

Boosting Postgres INSERT Performance by 2x With UNNEST

15 Nov 2024 6 min read

Read how you can double your Postgres INSERT performance using the UNNEST function.

AI

Combining Semantic Search and Full-Text Search in PostgreSQL (With Cohere, Pgvector, and Pgai)

15 Nov 2024 13 min read

Read how you can implement hybrid search in PostgreSQL by combining semantic and full-text search using Cohere, pgvector, and pgai.

PostgreSQL, Blog

Boost Your PostgreSQL Performance With Auto Chunk Size Recommendations

15 Nov 2024 2 min read

Meet our latest UI tooling addition, Chunk Size Recommendations—designed to help you boost Postgres performance by finely tuning your hypertable configs.

AI

Scaling Document Data Extraction With LLMs & Vector Databases

14 Nov 2024 13 min read

Learn how to use a vector database and LLM-powered intelligent document processing for faster and cost-effective structured data extraction.

Announcements & Releases

Stop Building Data Pipelines: Cross-Database Queries With PostgreSQL Foreign-Data Wrappers

14 Nov 2024 5 min read

You can now query across your Timescale services and other PostgreSQL databases from a central Timescale service using foreign-data wrappers—learn how.

AI

Parsing All the Data With Open-Source Tools: Unstructured and Pgai

13 Nov 2024 8 min read

Data parsing doesn’t have to be complicated. Learn how to use the PostgreSQL extension pgai and Unstructured.io to supercharge your document analysis.

PostgreSQL, Blog

How Trebellar Halved Storage Costs While Unlocking Real-Time Insights With PostgreSQL

13 Nov 2024 4 min read

Read how Trebellar is delivering real-time insights from 10 million new data points per day while cutting storage costs in half—all while using PostgreSQL.

Announcements & Releases

Postgres GUI, Reimagined with AI: Code Smarter With SQL Assistant

12 Nov 2024 4 min read

You can now write SQL more efficiently and debug faster with our AI-powered, modern Postgres GUI—meet the SQL Assistant.

Announcements & Releases

How We're Bringing Postgres Into the AI Era

12 Nov 2024 4 min read

Read how we’re blending Postgres and AI to make your database smarter, more accessible, and performant.

AI

Building a Reverse Video Search System With Mixpeek & PostgreSQL

8 Nov 2024 9 min read

Follow this step-by-step guide to learn how to create a reverse video search system with Mixpeek and PostgreSQL's AI extensions: pgvector and pgvectorscale.

PostgreSQL

PostgreSQL DISTINCT: TimescaleDB’s SkipScan Under Load

7 Nov 2024 4 min read

We benchmarked TimescaleDB's SkipScan under load to see what effect it has on DISTINCT queries.

AI

Vector Databases Are the Wrong Abstraction

29 Oct 2024 11 min read

Today’s vector databases disconnect embeddings from their source data. We should treat embeddings more like database indexes—here’s how.

AI

How to Automatically Create & Update Embeddings in PostgreSQL—With One SQL Query

29 Oct 2024 13 min read

Build RAG systems with ease and efficiency. Learn how to automate embedding creation and management with a single SQL query using pgai Vectorizer.

AI

Which OpenAI Embedding Model Is Best for Your RAG App With Pgvector?

29 Oct 2024 7 min read

What if testing your data with a new OpenAI embedding model was as easy as running a SQL query?

AI

Which RAG Chunking and Formatting Strategy Is Best for Your App With Pgvector

29 Oct 2024 10 min read

Pgai Vectorizer makes testing and experimenting with different RAG chunking and formatting approaches easy, helping you improve your AI system faster.

AI

How to Choose a Vector Database

22 Oct 2024 8 min read

Learn how to choose a vector database for your AI and machine learning applications, compare general-purpose vs. specialized databases, and more.

AWS Lambda

Using AWS Lambda with TimescaleDB for IoT Data Integration

18 Oct 2024 6 min read

Tips and tricks to help you integrate AWS Lambda and TimescaleDB for IoT data.

AI

How to Build an Image Search Application With OpenAI CLIP & PostgreSQL in JavaScript

17 Oct 2024 18 min read

See how you can build an image search engine using OpenAI CLIP and PostgreSQL for numerous applications, from e-commerce to healthcare and augmented reality.

AI

Building Multi-Tenant RAG Applications With PostgreSQL: Choosing the Right Approach

11 Oct 2024 5 min read

Learn how to pick the right approach to handle multi-tenancy for your use case when building multi-tenant RAG applications with PostgreSQL.

Announcements & Releases

PostgreSQL Migration Made Easier: Improving Our Live Migration Tool

11 Oct 2024 7 min read

Are you looking to migrate your database to Timescale? We have you covered! Learn about our live migration tool enhancements for easy, minimal-downtime migrations.