Bookmarks (744)

  • screenshot

    PostgreSQL: Useful new data types - Cybertec

    Using CREATE DOMAIN to Create New Data Types — If you want to create more advanced...

  • screenshot

    Amazon Web Services announced Amazon Relational Database Service (RDS) support for MySQL and PostgreSQL databases on AWS Outposts

    Amazon RDS Now Works on AWS Outposts — Let’s untangle this. RDS (Relational Database Service) is...

  • screenshot

    Bitnine Looks to Scale PostgreSQL

    Bitnine Looks to Scale Postgres with AGE — AgensGraph is a transactional graph database built on...

  • Random Strings and Integers That Actually Aren’t | End Point

    Generating Random Strings and Integers That Actually Aren’t — A look at creating “random-looking” coupon codes...

  • screenshot

    lesovsky/noisia

    Noisia: A 'Harmful Workload Generator' for Postgres — Creates things like deadlocks, transactions that do nothing...

  • screenshot

    Homepage

    Enterprise-Ready PostgreSQL | EDB Supercharges PostgreSQL — A portfolio of service offerings to help you on...

  • Features In PG13 - Deduplication in B-Tree Indexes - Highgo Software Inc.

    More Postgres 13 Features: Deduplication in B-Tree Indexes — Postgres 13, due later this year, has...

  • screenshot

    OnGres | Generated Columns vs. Triggers in PostgreSQL 12

    Generated Columns vs. Triggers in Postgres 12 — Postgres 12 introduced the idea of generated columns...

  • screenshot

    Calculating differences between rows in SQL - Cybertec

    Calculating Differences Between Rows in SQL — If you have lots of rows that represent changing...

  • https://static.sched.com/hosted_files/ossna2020/fc/Running%20Postgres-as-a-Service%20in%20Kubernetes.pdf

    PDF: Running Postgres in Kubernetes — A slidedeck based rundown of the top options for running Postgres...

  • screenshot

    Setup ora2pg for Oracle to Postgres Migration

    Setting Up ora2pg for an Oracle to Postgres Migration — I suspect if you have access...

  • PostgreSQL Anonymization On Demand

    Postgres Anonymization on Demand — If your database stores personally identifiable information – and it probably...

  • screenshot

    Cloud

    Timescale Cloud: Hosted, High-Performance PostgreSQL — Now available in 75+ regions across 3 major clouds. Analytics,...

  • Bruce Momjian: Postgres Blog

    Can Case Comparison Be Controlled? — “Let’s go over some Postgres case-precision behaviors like the handling...

  • screenshot

    13 Tips to Improve PostgreSQL Database Insert Performance

    13 Tips to Improve Insert Performance on Postgres and TimescaleDB — The first five tips are...

  • screenshot

    Join strategies and performance in PostgreSQL - Cybertec

    On Join Strategies and Performance — It’s worth understanding the three forms of join strategy Postgres...

  • Indexing JSONB columns in PostgreSQL | Vsevolod Solovyov

    A Story of Indexing JSONB Columns — A neat mix of story and tip when it...

  • system_stats extension for PostgreSQL

    Using the system_stats Extension to Monitor Postgres — system_stats is a new extension (out of EDB,...

  • screenshot

    Test Extensions With GitHub Actions

    Testing Extensions with GitHub Actions — pgxn-tools provides a Docker image with scripts to install and...

  • screenshot

    BDR Whitepaper Download

    Whitepaper: BDR - Advanced Clustering & Scaling for PostgreSQL — Learn more about Advanced Clustering &...

  • screenshot

    Wrapping Db2 with PostgreSQL - CYBERTEC

    Wrapping Db2 with Postgres — Db2 is a family of database products developed by IBM and...

  • PG Phriday: 10 Things Postgres Could Improve - Part 1 - 2ndQuadrant | PostgreSQL

    '10' Things Postgres Could Improve — An in-progress four part series (part 2 here) covering topics...

  • http://www.sai.msu.su/~megera/postgres/talks/json-unification-database-meetup-2020.pdf

    📊 PDF: It's Time for a JSON/JSONB Great Unification — This dense, technical slidedeck is for you...

  • screenshot

    PostgreSQL 13 Beta 1 Now Available in Amazon RDS Database Preview Environment

    Postgres 13 Beta 1 Now in Amazon RDS Database Preview Environment — RDS lets you run...

  • Bruce Momjian: Postgres Blog

    How to Force a Table to Have Just One Row — Bruce demonstrates how to force...

  • screenshot

    EnterpriseDB Rebrands to EDB; Continues to Lead in the PostgreSQL Movement

    EnterpriseDB Rebrands to EDB — EnterpriseDB are a popular company in the Postgres space so if...

  • screenshot

    SQL trickery: Hypothetical aggregates - CYBERTEC

    SQL Trickery: Hypothetical Aggregates — You can use this technique to determine the rank of a...

  • tuned, PG, and you

    tuned, Postgres, and You — tuned is a dynamic adaptive system tuning daemon (from Red Hat)...

  • screenshot

    PostgreSQL: ltree vs. WITH RECURSIVE - CYBERTEC

    ltree vs. WITH RECURSIVE — This is a follow up to Hans-Jürgen’s article on hierarchical queries.

  • screenshot

    Oracle to PostgreSQL: Reasons to Migrate - 2ndQuadrant | PostgreSQL

    Reasons to Migrate from Oracle to Postgres — This is truly a case of ‘preaching to...

  • screenshot

    citusdata/pg_auto_failover

    pg_auto_failover: Automated Failover and High-Availability Extension — Monitors and manages automated failover for a Postgres cluster.

  • Jepsen: PostgreSQL 12.3

    Jepsen Finds a Bug in Postgres 12.3 — The name ‘Jepsen’ is sure to stir emotions...

  • Running pgbackrest on FreeBSD

    Running pgbackrest on FreeBSD — pgbackrest is a backup and restore system for Postgres.

  • Bruce Momjian: Postgres Blog

    Controlling Server Variables at Connection Time — A brief tip, this. For example: psql 'options=-cwork_mem=100MB dbname=test'

  • screenshot

    A multi-node, elastic, petabyte scale, time-series database on Postgres for free (and more ways we are investing in our community)

    A Free, Multi-Node, Petabyte Scale, Time-Series Database on Postgres — Read more about Timescale’s multi-node time-series...

  • screenshot

    Control Runaway Postgres Queries With Statement Timeout

    Controlling Runaway Queries with Statement Timeouts — A well tuned database on good hardware is easily...

  • screenshot

    Understanding user management in PgBouncer - 2ndQuadrant | PostgreSQL

    Understanding User Management in PgBouncer — PgBouncer is a popular connection proxy and pooler for Postgres,...

  • screenshot

    xgenecloud/xgenecloud

    XgeneCloud: Instant REST and GraphQL APIs on any Database — Where ‘any’ includes Postgres, naturally :-)...

  • screenshot

    Release notes for Citus 9.3, the extension that scales out Postgres horizontally

    Citus 9.3 Released: The Postgres Horizontal Scaling Extension — Citus is the now Microsoft-owned Postgres extension...

  • screenshot

    Distributed SQL: a modern, cloud-native PostgreSQL

    Webinar | Distributed SQL: A Modern, Cloud-Native PostgreSQL — Hitting challenges scaling PostgreSQL, deploying it in...

  • How one word in PostgreSQL unlocked a 9x performance improvement

    How One Word in Postgres Unlocked a 9x Performance Improvement — The creator of a personal...

  • screenshot

    Whitepaper: Business Case for PostgreSQL Support

    Whitepaper: Business Case for Professional Support — Learn the importance of Professional Support for your mission-critical...

  • screenshot

    sqlancer/sqlancer

    SQLancer: A Tool for Detecting Logic Bugs in Database Systems — Considered a ‘research prototype’ for...

  • screenshot

    ankane/pghero

    PgHero 2.5: A Performance Dashboard for Postgres — Built in Ruby. And, yes, we have a...

  • screenshot

    pramsey/pgsql-http

    pgsql-http: An HTTP Client Extension for Postgres — If you need to make HTTP requests direct...

  • screenshot

    Backup Heroku PostgreSQL to AWS S3 Bucket [Step by Step Tutorial]

    A Step-by-Step Way to Backup a Heroku Postgres Database to an AWS S3 Bucket — Another...

  • screenshot

    10 Common PostgreSQL Errors - Percona Database Performance Blog

    10 Common Postgres Errors — Some quick fire common errors and warnings to watch out for,...