Avthar Sewrathan

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.

TimescaleDB vs. InfluxDB: Purpose Built Differently for Time-Series Data

18 Jul 2023 26 min read

An in-depth look into how TimescaleDB and InfluxDB stack up in terms of data model, query language, reliability, performance, ecosystem, operational management, and company/community support.

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.

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.

Do More on AWS With Timescale: 8 Services to Build Time-Series Apps Faster

15 Nov 2022 11 min read

Learn about the most popular AWS tools that Timescale customers incorporate into their data architectures to speed up development time.

How to Write Better Queries for Time-Series Data Analysis With Custom SQL Functions

23 Jun 2022 14 min read

There is a better way to explore and analyze time-series data with PostgreSQL: hyperfunctions. Learn how to ease your workload with faster and simpler data analysis using TimescaleDB.

Analyze millions of NFT sales on OpenSea using PostgreSQL and TimescaleDB

29 Oct 2021 11 min read

Introducing the Timescale NFT Starter Kit, a step-by-step guide to get up and running with collecting, storing, analyzing and visualizing NFT data from OpenSea. And the Time Travel Tigers NFT Collection!

Massive Scale for Time-Series Workloads: Introducing Continuous Aggregates for Distributed Hypertables in TimescaleDB 2.5

28 Oct 2021 13 min read

With this release, we introduce continuous aggregates in multi-node TimescaleDB, support for Postgres 14, and support for time zones in time_bucket_ng (under experimental).

Grow Worry-Free: Storage Autoscaling on Timescale

7 Oct 2021 7 min read

Available today in Timescale: Automatically increase database storage as your application grows, while instituting cost constraints to make sure you stay within budget.

TimescaleDB 2.3: Improving Columnar Compression for Time-Series on PostgreSQL

26 May 2021 9 min read

TimescaleDB 2.3 makes built-in columnar compression even better by enabling inserts directly into compressed hypertables, as well as automated compression policies on distributed hypertables.

How to Store Time-Series Data in MongoDB and Why That’s a Bad Idea

17 Dec 2020 19 min read

TimescaleDB vs MongoDB: 260 % higher insert performance, up to 54x faster queries, and simpler implementation for time-series data.

Speed up Grafana by auto-switching between different aggregations, using PostgreSQL

11 Aug 2020 7 min read

Learn how (and why) to use PostgreSQL and TimescaleDB to speed up your Grafana drill downs: step-by-step guide to enable "auto-switching" between aggregations, depending on the time interval.

How to visualize timeshifts to compare metrics over time in Grafana using PostgreSQL

6 Aug 2020 8 min read

Learn how (and why) to combine PostgreSQL, TimescaleDB, and Grafana to visualize timeshifts and compare how your time-series metrics change over time.

9 Reasons to Choose Timescale vs. Influx and AWS Timestream

2 Jul 2020 3 min read

Why should you choose TimescaleDB over InfluxDB or AWS Timestream as your time-series database of choice? Let us count the ways (9 to be exact).

[New Webinar] Grafana 101 Part III: Interactivity, Templating and Sharing

11 Jun 2020 3 min read

Take your dashboards to the next level with step-by-step demos, queries, and pro tips that’ll get you creating interactive, reusable, and shareable Grafana dashboards in less time.

“Grafana 101: Getting Started with Alerting” Recap and Resources

3 Jun 2020 9 min read

Get step-by-step demos and learn how to define 3 different alert rules and send notifications through channels like Slack, PagerDuty and OpsGenie.

[New Webinar] Grafana 101 Part II: Getting Started with Alerts

8 May 2020 3 min read

Jumpstart your monitoring journey with step-by-step demos, queries, and pro tips that'll get you set up with custom notifications for incidents in your systems, so you can take action immediately.

“Guide to Grafana 101: Creating Awesome Visualizations” Recap and Resources

30 Apr 2020 9 min read

Get step-by-step demos and learn how to create 6 different visuals for DevOps, IoT, geospatial, and public data scenarios (and beyond).

How to use Grafana variables to make more interactive dashboard visualizations (aka a lot less boring, a lot more useful)

20 Apr 2020 8 min read

Learn how to add features that allow you, your teammates, and your stakeholders to drill into specific details, see all results, and quickly get the info you need.

How to Build More Accurate Grafana Trend Lines: Plot Two Variables with Series-Override