Bookmarks (163)

  • Index Merges vs Composite Indexes in Postgres and MySQL

    Index Merges vs Composite Indexes — Is it faster to use a composite index (a.k.a. a...

  • screenshot

    GitHub - pgvector/pgvector: Open-source vector similarity search for Postgres

    pgvector: Vector Similarity Search Extension — Supports L2 distance, inner product, and cosine distance. There’s a whole...

  • screenshot

    GitHub - zekenie/d2-erd-from-postgres: Create a D2 ERD Diagram from your existing postgres schema

    Create D2 ERD Diagrams from Postgres Schemas — A simple Node script that can turn the...

  • screenshot

    Using Postgres as a task queue for rowdy Gophers

    Using Postgres as a Task Queue for Rowdy Gophers — A developer walks through his experience of...

  • screenshot

    Unblock 2022

    📅  Register for Unblock - A CI/CD Conference by Buildkite

  • screenshot

    New – A Fully Managed Schema Conversion in AWS Database Migration Service | Amazon Web Services

    AWS Database Migration Service Adds Managed Schema Migration — AWS Database Migration Service (DMS) is a...

  • screenshot

    How We Built Fly Postgres

    How Fly.io Runs Its New Postgres Platform — We’re big fans of Fly (a sort of...

  • screenshot

    Percentage Calculations Using Postgres Window Functions

    Percentage Calculations Using Window Functions — Rather than fetching your data and then performing percentage calculations...

  • screenshot

    Expanding the Boundaries of PostgreSQL: Announcing a Bottomless, Consumption-Based Object Storage Layer Built on Amazon S3

    Timescale's 'Bottomless' Object Storage Layer on Top of S3 — Timescale continues to innovate with its...

  • screenshot

    GitHub - morphismtech/squeal: Squeal, a deep embedding of SQL in Haskell

    Squeal: A 'Deep Embedding' of SQL in Haskell — Essentially a client library that brings SQL...

  • explain.dalibo.com

    The Dalibo Postgres Execution Plan Visualizer — Give this EXPLAIN ANALYZE's output and take a better...

  • screenshot

    PostgreSQL do different equality predicates make a difference?

    Do Different Equality Predicates Make a Difference? — Namely, IN vs =. Spoiler: No, for Postgres...

  • screenshot

    Postgres Query Boost: Using ANY Instead of IN

    A Query Boost by Using ANY Instead of IN? — Matt makes a case for using...

  • screenshot

    A serverless architecture for analyzing PostgreSQL logs with pgBadger | Amazon Web Services

    A Serverless Architecture for Analyzing Postgres Logs with pgBadger — pgBadger is a log analysis tool (written...

  • Crunchy Bridge

    We’re All About Great Support — “I’m learning so much about @PostgreSQL from the @crunchydata support...

  • Postgres OnLine Journal

    The Power of Variadic Unnesting — There’s no obvious "big news" this week, so let’s go...

  • screenshot

    Postgres at Scale: Running Multiple PgBouncers

    Postgres at Scale: Running Multiple PgBouncers — Connection pooling with pgBouncer is great, but at particularly...

  • screenshot

    Reducing replication lag with IO concurrency in Postgres 15

    Reducing Replication Lag with I/O Concurrency in Postgres 15 — Postgres 15 comes with key replication...

  • screenshot

    PolyScale.ai – Database Edge Caching With Deno Deploy

    Using Postgres with Deno Deploy — Accessing Postgres data at the edge presents new challenges with...

  • screenshot

    PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released!

    PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released — A bevy of bug fix releases...

  • A tribute to PostgreSQL 10 | Jonathan Katz

    A Tribute to 2017's Postgres 10 — Five years after each major Postgres release, the tide...

  • screenshot

    EXPLAIN that parameterized statement in PostgreSQL! - CYBERTEC

    EXPLAIN That Parameterized Statement — The output of EXPLAIN (ANALYZE, BUFFERS) is always useful, but can...

  • screenshot

    Upsert in SQL: what is an upsert, and when should you use one?

    What is an 'Upsert' and When Should You Use One? — This comes from CockroachDB but...

  • screenshot

    Read Before You Upgrade: Best Practices for Choosing Your PostgreSQL Version

    Read Before You Upgrade: Best Practices for Choosing a Postgres Version — Reflections on when to consider...

  • screenshot

    JSON in PostgreSQL: The Ultimate Guide

    JSON in PostgreSQL: The Ultimate Guide — I encountered this when putting together some JSONB queries...

  • screenshot

    Migrate ROW CHANGE TIMESTAMP from IBM Db2 for z/OS to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition | Amazon Web Services

    How to Recreate ROW CHANGE TIMESTAMP from IBM Db2 on Amazon RDS or Aurora — In...

  • Devrim Gunduz's PostgreSQL Blog

    Improved Aarch64 (arm64) Support Now Available in the Postgres RPM Repository — You’ve been able to...

  • Postgres v15 - a billion transactions later

    Postgres 15, A Billion Transactions Later — Last week B-tree and BRIN indexes battled it out,...

  • pg_builder 2.1.0 released with support for Postgres 15 syntax

    pg_builder 2.1.0: A Query Builder in PHP for Postgres — Curiously it contains a partial reimplementation...

  • screenshot

    Datadog PostgreSQL Monitoring | Datadog

    Monitor Custom PostgreSQL Metrics with Datadog’s OOTB Dashboards

  • screenshot

    GitHub - orafce/orafce: The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle...

    Orafce 4.0: Oracle Compatibility Functions for Postgres — Orafce implements some of the functions from Oracle...

  • screenshot

    Listening to Postgres: How LISTEN and NOTIFY Syntax Promote High Availability at the Application Layer

    How LISTEN and NOTIFY Promote High Availability at the App Layer — Shaun looks at some...

  • screenshot

    Using PostgreSQL® JSON functions to navigate reviews of restaurants in India

    Using JSON Functions to Navigate Restaurant Reviews — Practical examples of using Postgres’s JSON querying functionality...

  • screenshot

    What is PostgreSQL commitfest and how to contribute

    What is PostgreSQL Commitfest and How to Contribute — A time-tested method for contributing to the...

  • screenshot

    Rewrite OR to UNION in PostgreSQL queries - CYBERTEC

    On Rewriting OR to UNION in Your Queries — A few years ago, Laurenz wrote about...

  • screenshot

    Postgres Insider Terminology

    Postgres Insider Terminology — Want to seem like one of the cool Postgres kids? No? Well,...

  • screenshot

    Postgres Databases and Schemas

    Postgres Databases and Schemas — Craig has worked on Postgres databases of every scale, but they...

  • https://tsdb.co/13-tips-data-agg-blog

    Tips for Better Data Aggregation in PostgreSQL and TimescaleDB — Get familiar with TimescaleDB continuous aggregates,...

  • Postgres: Safely renaming a table with no downtime using updatable views — brandur.org

    Safely Renaming a Table with No Downtime Using Updatable Views — Just use ALTER TABLE x...

  • screenshot

    btree vs. BRIN index in PostgreSQL data warehouses

    B-tree vs. BRIN Indexes in Postgres Data Warehouses — Hans-Jürgen describes it as an ‘epic battle’...

  • PGroonga - Make PostgreSQL fast full text search platform for all languages!

    PGroonga: Extend Full Text Search Features to All Languages — Brings the Groonga fulltext search engine...

  • screenshot

    GitHub - jameshy/pgdump-aws-lambda: Lambda function for executing pg_dump and streaming the output to s3.

    pgdump-aws-lambda: Stream pg_dump Output to S3 via AWS Lambda — There are other ways to do...

  • Postgres OnLine Journal

    PostgreSQL 15 64-Bit FDWs for Windows — Specifically, 64 bit binaries for file_textarray_fdw (process arbitrarily delimited...

  • screenshot

    GitHub - powa-team/pg_stat_kcache: Gather statistics about physical disk access and CPU consumption done by backends.

    pg_stat_kcache: Gather Statistics About Disk Access and CPU Consumption — Sits atop pg_stat_statements and creates a...

  • Cross-partition Uniqueness Guarantee with Global Unique Index - Highgo Software Inc.

    Cross-Partition Uniqueness Guarantees with Global Unique Indexes — More deep diving from the folks at Highgo.

  • screenshot

    Data Loading in Postgres for Newbies

    Data Loading in Postgres for Newbies — Quickly covers various routes to ingest data from CSV,...

  • screenshot

    Making Postgres More Affordable - New Low Cost Plans on Crunchy Bridge

    Making Postgres More Affordable. Starting at $10/Month

  • screenshot

    Distributed PostgreSQL comes to Azure Cosmos DB

    Azure Cosmos DB Brings in Distributed Postgres — Azure Cosmos DB is a long-standing ‘multi-model’ managed...

  • screenshot

    Postgres FM

    ▶  Postgres FM: A Weekly Postgres Podcast — We’ve mentioned this show a few times, but it...

  • screenshot

    PostgresML is 8-40x faster than Python HTTP microservices

    'PostgresML Is 8-40x Faster Than Python HTTP Microservices' — Postgres gets compared to MySQL, SQL Server...