Matvey Arye - 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.

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.

A Different and (Often) Better Way to Downsample Your Prometheus Metrics

22 Oct 2021 15 min read

A better option for downsampling Prometheus metrics, enabling developers to do accurate and flexible trend analysis on those metrics over long periods of time with high performance and reduced storage costs.

Simplified Prometheus monitoring for your entire organization with Promscale

18 Aug 2021 11 min read

We’re excited to announce multi-tenancy support in Promscale. We’ve built Promscale as a centralized store for metrics, and now developers can enjoy the same operational maturity and query flexibility when storing metrics across their entire organization.

Promscale 0.4: Drawing Inspiration from Cortex to Rewrite Support for Prometheus High-Availability

19 May 2021 13 min read

Introducing Promscale 0.4 with new capabilities including better support for Prometheus high-availability, support for multi-tenancy, improved user permissions (using role-based access control), and more.

Introducing Tobs: Deploy a Full Observability Suite for Kubernetes in Two Minutes

18 Feb 2021 7 min read

Tobs deploys a full open-source observability suite into your Kubernetes cluster with a single command. Learn how and why we built it and start collecting, analyzing, and visualizing all of your metrics in a matter of minutes ⏰ .

Promscale: An analytical platform and long-term store for Prometheus, with the combined power of SQL and PromQL

6 Oct 2020 14 min read

We just announced Promscale: a new open-source analytical platform & long-term store for Prometheus, with the combined power of SQL and PromQL. Learn why we built it, how it works, and how to get started right away.

Rethinking the Database Materialized View as an Index

12 Jun 2019 4 min read

By utilizing the properties of time-series data, can we make the maintenance of materialized views efficient enough so they act like indexes?

SQL vs. Flux: Choosing the right query language for time-series data

2 Aug 2018 10 min read

An examination of the strengths and weaknesses of SQL, and why query planners exist, by way of comparing TimescaleDB and InfluxDB.

Optimizing queries on TimescaleDB hypertables with thousands of partitions

27 Jun 2018 3 min read

How 0.10 introduces 15x improvements in query planning times.

How to scale PostgreSQL 10 using table inheritance and declarative partitioning

8 Nov 2017 11 min read

PG10 introduces quite a few substantial new features: logical replication, full text search support for JSON / JSONB, cross-column statistics, and better support for parallel queries. Overall, PG10 is a significant milestone in the steady development of a venerable open-source database.