AI - Timescale Blog

How We Made PostgreSQL a Better Vector Database

25 Sep 2023 24 min read

3x search performance vs. Weaviate. 40%-1,500% performance improvement vs. pgvector. Meet Timescale Vector, the PostgreSQL++ vector database for AI applications.

How We Made PostgreSQL a Better Vector Database

Supercharge Your AI Agents With Postgres: An Experiment With OpenAI's GPT-4

26 Jul 2023 3 min read

Read how you can work with AI agents as intermediaries between AI and databases.

How to Build LLM Applications With pgvector Vector Store in LangChain

12 Jul 2023 11 min read

“Hello World” for pgvector and LangChain! Learn how to build LLM applications with LangChain framework, using PostgreSQL and pgvector as a vector database for embeddings data.

Jupyter Notebook Tutorial: Setting Up Python & Jupyter Notebooks on macOS for OpenAI Exploration

5 Jul 2023 2 min read

Unlock the power of Python and OpenAI with our step-by-step Jupyter Notebook tutorial.

Nearest Neighbor Indexes: What Are ivfflat Indexes in pgvector and How Do They Work

30 Jun 2023 11 min read

A primer on the pgvector’s Inverted File Flat (ivfflat) algorithm for approximate nearest neighbor search.

PostgreSQL as a Vector Database: Create, Store, and Query OpenAI Embeddings With pgvector

21 Jun 2023 18 min read

"Hello world” for pgvector. Learn how to use PostgreSQL as a vector database and build a simple Retrieval Augmented Generation example.