| 493 | 
                        Vector databases are the wrong abstraction | 
                        2024-10-29 | 
                      
                    
                      
                        | 155 | 
                        Using Postgres for Everything | 
                        2024-05-20 | 
                      
                    
                      
                        | 127 | 
                        Pgvector Is Now Faster Than Pinecone at 75% Less Cost | 
                        2024-06-11 | 
                      
                    
                      
                        | 80 | 
                        How We Made PostgreSQL a Better Vector Database | 
                        2023-09-25 | 
                      
                    
                      
                        | 50 | 
                        We scaled PostgreSQL to 350 TB+ (with 10B new records/day) | 
                        2023-11-02 | 
                      
                    
                      
                        | 37 | 
                        Making Postgres backups 100x faster via EBS snapshots and pgBackRest | 
                        2023-08-31 | 
                      
                    
                      
                        | 29 | 
                        Scaling PostgreSQL with Amazon S3 | 
                        2023-03-28 | 
                      
                    
                      
                        | 22 | 
                        What Is a Time-Series Plot, and How Can You Create One? | 
                        2023-06-27 | 
                      
                    
                      
                        | 20 | 
                        The New Timescale | 
                        2023-05-17 | 
                      
                    
                      
                        | 20 | 
                        How We Made Real-Time Data Aggregation in Postgres Faster by 50k% | 
                        2024-03-20 | 
                      
                    
                      
                        | 19 | 
                        We Designed a Resilient Vector Embedding Creation System for PostgreSQL Data | 
                        2023-11-10 | 
                      
                    
                      
                        | 15 | 
                        Advice on PgBouncer from a Support Engineer | 
                        2023-09-14 | 
                      
                    
                      
                        | 14 | 
                        Pgvectorscale: Making PostgreSQL a Better AI Database | 
                        2024-06-11 | 
                      
                    
                      
                        | 14 | 
                        Is Postgres Partitioning That Hard? An Introduction to Hypertables | 
                        2023-10-11 | 
                      
                    
                      
                        | 13 | 
                        Why PostgreSQL Is the Bedrock for the Future of Data | 
                        2024-04-24 | 
                      
                    
                      
                        | 13 | 
                        New Python library for using PostgreSQL as a vector database for AI applications | 
                        2023-09-28 | 
                      
                    
                      
                        | 12 | 
                        A Complete Guide to Creating and Storing Embeddings for PostgreSQL Data | 
                        2023-11-10 | 
                      
                    
                      
                        | 12 | 
                        What are ivfflat indexes in pgvector and how they work? | 
                        2023-06-30 | 
                      
                    
                      
                        | 12 | 
                        Scaling Document Data Extraction with LLMs and Vector Databases | 
                        2024-11-15 | 
                      
                    
                      
                        | 10 | 
                        Timescale acquires PopSQL | 
                        2024-04-04 | 
                      
                    
                      
                        | 10 | 
                        Visualizing IoT data at scale by Michael Stonebraker | 
                        2023-05-18 | 
                      
                    
                      
                        | 9 | 
                        What InfluxDB Got Wrong | 
                        2023-10-05 | 
                      
                    
                      
                        | 8 | 
                        SkipScan Under Load | 
                        2024-11-07 | 
                      
                    
                      
                        | 6 | 
                        How We Made PostgreSQL as Fast as Pinecone for Vector Data | 
                        2024-06-11 | 
                      
                    
                      
                        | 6 | 
                        Teaching Postgres New Tricks: SIMD Vectorization for Faster Analytical Queries | 
                        2023-11-15 | 
                      
                    
                      
                        | 5 | 
                        Petabye Postgres | 
                        2024-09-20 | 
                      
                    
                      
                        | 5 | 
                        Why RAG is more than just vector search | 
                        2024-09-16 | 
                      
                    
                      
                        | 4 | 
                        A Brief History of AI: How Did We Get Here, and What's Next? | 
                        2024-07-18 | 
                      
                    
                      
                        | 4 | 
                        Vector Search Queries with Time Filters in Pgvector | 
                        2024-04-01 | 
                      
                    
                      
                        | 4 | 
                        Building Columnar Compression for Large PostgreSQL Databases | 
                        2023-11-14 | 
                      
                    
                      
                        | 3 | 
                        State of Postgres (2023) | 
                        2023-12-25 | 
                      
                    
                      
                        | 3 | 
                        Why we moved away from K8s StatefulSets | 
                        2024-10-10 | 
                      
                    
                      
                        | 3 | 
                        How We Built a Content Recommendation System with PostgreSQL | 
                        2024-10-05 | 
                      
                    
                      
                        | 3 | 
                        Hyperstore: A Hybrid Row-Columnar Storage Engine for Real-Time Analytics | 
                        2024-09-16 | 
                      
                    
                      
                        | 3 | 
                        Dynamic PostgreSQL | 
                        2023-12-28 | 
                      
                    
                      
                        | 3 | 
                        Top PostgreSQL Extensions | 
                        2023-11-10 | 
                      
                    
                      
                        | 3 | 
                        Wrangling Table Bloat in Large PostgreSQL Tables | 
                        2023-11-04 | 
                      
                    
                      
                        | 3 | 
                        The Problem with Locks and PostgreSQL Partitioning (and How to Fix It) | 
                        2023-10-12 | 
                      
                    
                      
                        | 3 | 
                        How to Reduce Your PostgreSQL Database Size | 
                        2023-10-07 | 
                      
                    
                      
                        | 3 | 
                        Pg_partman vs. Hypertables for Postgres Partitioning | 
                        2023-09-13 | 
                      
                    
                      
                        | 3 | 
                        How to Work with Time Series in Python | 
                        2023-08-01 | 
                      
                    
                      
                        | 3 | 
                        Timescale’s storage is becoming usage-based [pdf] | 
                        2023-06-14 | 
                      
                    
                      
                        | 3 | 
                        Timescale — Postgres for time-series data | 
                        2023-05-02 | 
                      
                    
                      
                        | 2 | 
                        The New Timescale | 
                        2023-05-24 | 
                      
                    
                      
                        | 2 | 
                        Function pipelines: Building functional programming into PostgreSQL using custom | 
                        2024-08-05 | 
                      
                    
                      
                        | 2 | 
                        A Beginner's Guide to Vector Embeddings | 
                        2024-04-30 | 
                      
                    
                      
                        | 2 | 
                        Common Connection Errors in PostgreSQL and How to Solve Them | 
                        2024-04-25 | 
                      
                    
                      
                        | 2 | 
                        State of Postgres 2023 | 
                        2023-12-15 | 
                      
                    
                      
                        | 2 | 
                        Creating a Fast Time-Series Graph with Postgres Materialized Views | 
                        2023-11-28 | 
                      
                    
                      
                        | 2 | 
                        The PostgreSQL job scheduler you always wanted (use with caution) | 
                        2023-10-13 | 
                      
                    
                      
                        | 2 | 
                        Optimizing Postgres indexes for performance tuning | 
                        2023-09-21 | 
                      
                    
                      
                        | 2 | 
                        Key Postgres parameters to fine tune | 
                        2023-09-20 | 
                      
                    
                      
                        | 2 | 
                        When to Consider Postgres Partitioning | 
                        2023-09-12 | 
                      
                    
                      
                        | 2 | 
                        Best Practices for Picking PostgreSQL Data Types | 
                        2023-08-24 | 
                      
                    
                      
                        | 2 | 
                        Understanding AWS RDS Cost | 
                        2023-07-07 | 
                      
                    
                      
                        | 2 | 
                        Timescale storage is now usage-based | 
                        2023-06-29 | 
                      
                    
                      
                        | 2 | 
                        A PostgreSQL Developer’s Perspective: 5 Interesting Patches from Jan Commitfest | 
                        2023-03-08 | 
                      
                    
                      
                        | 1 | 
                        Postgres GUI, Reimagined with AI: Code Smarter with SQL Assistant | 
                        2024-11-13 | 
                      
                    
                      
                        | 1 | 
                        Boost Postgres Performance by 7x with Chunk-Skipping Indexes | 
                        2024-09-18 | 
                      
                    
                      
                        | 1 | 
                        What We're Excited About PostgreSQL 17 | 
                        2024-09-12 | 
                      
                    
                      
                        | 1 | 
                        What Is ClickHouse and How Does It Compare to TimescaleDB for Time Series? | 
                        2024-08-01 | 
                      
                    
                      
                        | 1 | 
                        Pgai Simplifies Workflows for RAG Applications on PostgreSQL | 
                        2024-06-19 | 
                      
                    
                      
                        | 1 | 
                        Best Practices for Query Optimization on PostgreSQL | 
                        2023-12-09 | 
                      
                    
                      
                        | 1 | 
                        Real-Time Analytics in Postgres: Why It's Hard (and How to Solve It) | 
                        2023-10-16 | 
                      
                    
                      
                        | 1 | 
                        Is Postgres Partitioning That Hard? An Introduction to Hypertables | 
                        2023-10-12 | 
                      
                    
                      
                        | 1 | 
                        Allowing DML operations in highly compressed time-series data in PostgreSQL | 
                        2023-10-03 | 
                      
                    
                      
                        | 1 | 
                        Estimating RDS Costs | 
                        2023-07-24 | 
                      
                    
                      
                        | 1 | 
                        How to Fix Transaction ID Wraparound | 
                        2023-05-11 | 
                      
                    
                      
                        | 4 | 
                        Boosting Postgres Insert Performance by 50% with Unnest | 
                        2024-11-16 | 
                      
                    
                      
                        | 4 | 
                        How to Create (Lots of) Sample Time-series Data with PostgreSQL (2021) | 
                        2024-11-23 | 
                      
                    
                      
                        | 2 | 
                        Benchmarking PostgreSQL Batch Ingest | 
                        2024-12-03 | 
                      
                    
                      
                        | 3 | 
                        Understanding DiskANN | 
                        2024-12-10 | 
                      
                    
                      
                        | 5 | 
                        Stop Paying the OpenAI Tax: The Emerging Open-Source AI Stack | 
                        2024-12-18 | 
                      
                    
                      
                        | 3 | 
                        Evaluating general purpose vs. domain specific models for financial RAG | 
                        2024-12-20 | 
                      
                    
                      
                        | 4 | 
                        Stop Over-Engineering AI Apps | 
                        2025-02-19 | 
                      
                    
                      
                        | 3 | 
                        How to Build a RAG System with Anthropic Claude on AWS | 
                        2025-03-12 | 
                      
                    
                      
                        | 2 | 
                        Timescale architecture for real-time analytics [pdf] | 
                        2025-03-21 | 
                      
                    
                      
                        | 1 | 
                        Speed Up Triggers by 7x with Transition Tables | 
                        2025-03-20 | 
                      
                    
                      
                        | 3 | 
                        Postgres vs. Qdrant Vector Database Comparison | 
                        2025-04-29 | 
                      
                    
                      
                        | 1 | 
                        Architecting Agentic AI: Lessons Learned Engineering Timescale's SQL Assistant | 
                        2025-05-20 |