Bookmarks (141)

  • screenshot

    Benchmark Amazon RDS for PostgreSQL Single-AZ DB instance, Multi-AZ DB instance, and Multi-AZ DB Cluster deployments | Amazon Web Services

    Benchmarking Amazon RDS for PostgreSQL Deployment Options — A performance comparison between RDS for PostgreSQL Single-AZ...

  • screenshot

    RAG on structured data with PostgreSQL

    RAG on Structured Data with Postgres — Pamela shows off a Python, React and Postgres-based approach...

  • How much speed you’re leaving at the table if you use default locale? – select * from depesz;

    How Much Speed Are You Leaving at the Table if You Use the Default Locale? — A...

  • screenshot

    Pgvector Is Now Faster than Pinecone at 75% Less Cost

    Boosting Postgres's Vector Performance with pgvectorscale — How? It’s thanks to a new open source Postgres...

  • screenshot

    Welcome! You are invited to join a webinar: Optimizing slow queries with EXPLAIN to fix bad query plans. After registering, you will receive a confirmation email about joining the webinar.

    Register Now: Optimizing Slow Queries with EXPLAIN to Fix Bad Query Plans — The focus of...

  • screenshot

    How to Get the Most out of Postgres Memory Settings | Tembo

    How to Get the Most Out of Postgres' Memory Settings — Samay Sharma said it better...

  • screenshot

    PGTT Extension for Global Temporary Tables in PostgreSQL - HexaCluster

    pgtt 4.0: Manage and Use Oracle-Style Global Temporary Tables — For those situations where you want...

  • screenshot

    GitHub - ChrisBellew/pg-ferret: 🔍️ All-in-one tracing toolkit for Postgres

    PG Ferret: An All-in-One Tracing Toolkit for Postgres — A new project that shows a lot...

  • screenshot

    Why do I have a slow COMMIT in PostgreSQL?

    Why Do I Have a Slow COMMIT? — When it comes to committing a transaction, the...

  • How engaging was PGConf.dev really?

    How Engaging Was PGConf.dev Really? — PGConf.dev took place last week and was a great success...

  • Why upgrade PostgreSQL?

    Why Upgrade Postgres? Here's Exactly Why — It’s been over two years since we linked to...

  • screenshot

    PostgreSQL 17 Beta 1 Released!

    ⭐  PostgreSQL 17 Beta 1 Released — Time wasn’t on our side with our break last...

  • SQLFluff

    SQLFluff: A SQL Linter 'for Humans' — Built in Python, a SQL linter that covers a...

  • screenshot

    Introducing pgCompare: The Ultimate Multi-Database Data Comparison Tool | Crunchy Data Blog

    Introducing pgCompare: A Multi-Database Comparison Tool — pgCompare is an open source tool fresh out of...

  • screenshot

    GitHub - k1LoW/tbls: tbls is a CI-Friendly tool for document a database, written in Go.

    tbls: A CI-Friendly Tool for Documenting Databases — Document a database automatically in Markdown format with...

  • RAG app with Postgres and pgvector

    Building a RAG App with Postgres and pgvector — RAG (Retrieval Augmented Generation) is a technique...

  • Custom PostgreSQL extensions with Rust | boringSQL

    Creating Custom Postgres Extensions with Rust — pgrx is (probably) the way to go, and here’s...

  • screenshot

    Foreign keys in PostgreSQL: Circular dependencies

    Circular Dependencies in Foreign Keys — A needs B and B needs A. Uh-oh! How can...

  • screenshot

    Controlling Resource Consumption on a PostgreSQL Server Using Linux cgroup2

    Controlling Resource Consumption with Linux's cgroup2 — Control groups constrain the resources allocated to processes and...

  • screenshot

    Introducing New Heroku Postgres Essential Plans Built On Amazon Aurora

    Heroku Introduces Heroku Postgres Essentials — A pioneer of scaling out a huge Postgres platform, Heroku...

  • screenshot

    Introducing pg_timeseries: Open-source time-series extension for PostgreSQL | Tembo

    Introducing pg_timeseries: A New Time-Series Extension — Billed as a simple, open source way to manage...

  • screenshot

    PostgreSQL Stories: From slow query to fast—via stats | Render Blog

    From Slow Query to Fast — via Stats — We previously linked to Render’s ‘Simple Query...

  • screenshot

    PostgreSQL

    PostgreSQL Learning Hub from Redgate — Explore PostgreSQL content, learn about upcoming events, join community discussions,...

  • https://jaywhy13.hashnode.dev/that-time-postgresql-said-no-thanks-i-dont-need-your-index

    When Postgres Said 'No Thanks, I Don't Need Your Index' — It’s story time! Jean-Mark presents...

  • In-memory disk for PostgreSQL temporary files

    Using In-Memory Disk for Postgres' Temporary Files — Postgres produces temporary files under various circumstances, including...

  • screenshot

    How to Collapse Your Stack Using PostgreSQL for Everything

    How to Collapse Your Stack Using Postgres for.. Everything — If ‘stack sprawl’ is a problem...

  • screenshot

    GitHub - eakmanrq/sqlframe: Taking the Spark out of PySpark by generating SQL

    SQLFrame: Taking the Spark Out of PySpark by Generating SQL — A dataframe library that can...

  • screenshot

    GitHub - ankane/pghero: A performance dashboard for Postgres

    PgHero 3.5: A Performance Dashboard for Postgres — A dashboard built as a (Ruby on) Rails...

  • screenshot

    What’s new with Postgres at Microsoft, 2024 edition

    What’s New with Postgres at Microsoft, 2024 Edition — Partly thanks to buying Citus Data and...

  • screenshot

    PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released!

    Postgres 16.3, 15.7, 14.12, 13.15, and 12.19 Released — Right on schedule, the Postgres team has...

  • screenshot

    Making a Postgres query 1,000 times faster

    Making a Postgres Query 1,000 Times Faster — If you want to get attention for a...

  • screenshot

    E.1. Release 17

    The Draft Postgres 17 Release Notes — Bruce just announced he’s completed the first draft of...

  • screenshot

    paradedb/pg_lakehouse at dev · paradedb/paradedb

    pg_lakehouse: Query Any Data Lake from Postgres — An extension that lets you query object stores...

  • Advanced psql scripting with coproc

    Advanced psql Scripting with coproc — coproc is a shell command that runs a process asynchronously...

  • How not to change PostgreSQL column type | boringSQL

    How Not to Change Postgres Column Type — ALTER TABLE .. ALTER COLUMN is fine in...

  • screenshot

    Understanding Postgres Database Schemas and the search_path

    Understanding Postgres Schemas and search_path — The developers of the Dolt database have a lot of...

  • screenshot

    What's new in pgvector v0.7.0

    What's New in pgvector v0.7 — We mentioned pgvector’s rather exciting v0.7 release last week, but...

  • Hacking on PostgreSQL is Really Hard

    Hacking on PostgreSQL is Really Hard — Robert has consistently been in the top ten committers...

  • screenshot

    GitHub - HexaCluster/pgdsat: PostgreSQL Database Security Assessment Tool

    pgdsat: A Postgres Database Security Assessment Tool — Checks around 70 security controls on your clusters...

  • Saturation Arithmetic with a PostgreSQL Extension

    Saturation Arithmetic with a Postgres Extension — Saturation arithmetic is the concept of bounding the results...

  • screenshot

    cursor_tuple_fraction and the PostgreSQL JDBC driver

    cursor_tuple_fraction and PostgreSQL JDBC — Laurenz had me at the first sentence: “This article is a...

  • The Notifier Pattern for Applications That Use Postgres

    The Notifier Pattern for Apps That Use Postgres — Brandur is a big fan of Postgres’s...

  • PG Phriday: Papa's Got a Brand New RAG

    Papa's Got a Brand New RAG — RAG (Retrieval-Augmented Generation) is a technique used alongside large...

  • The 150x pgvector speedup: a year-in-review | Jonathan Katz

    The 150x pgvector Speedup: A Year in Review — pgvector provides Postgres with extra data types,...

  • screenshot

    Crunchy Bridge for Analytics: Your Data Lake in... | Crunchy Data Blog

    Crunchy Bridge for Analytics: Your Data Lake in Postgres? — Marco ponders: “What if you could...

  • screenshot

    Squawk — a linter for Postgres migrations

    Squawk: A Linter for Postgres Migrations — Prevent unexpected downtime caused by database migrations and encourage...

  • screenshot

    GitHub - tembo-io/pg_tier: Postgres Extension written in Rust, to enable data tiering to AWS S3

    pg_tier: Tier Data to External Amazon S3 Storage — Once data becomes older or much less...

  • screenshot

    Postgres Bloat Minimization

    Postgres Bloat Minimization — Tables occupying more space than expected is a common cause of complaint,...

  • screenshot

    PeerDB: Fast, Simple, Cost-effective Postgres Replication

    PeerDB: A Simple, Fast Way to Replicate Postgres Data Elsewhere — A data replication system built...

  • screenshot

    Release v7.0.0 · salsita/node-pg-migrate

    node-pg-migrate 7.0: Database Migration Management for Postgres — Lots of cleanups and refactoring from the project’s...