Picture wall - Anayrat links

Picture Wall - 859 pics

PostgreSQL Column Limits | Stormatics

That Guy From Delhi: Speed up JOIN Planning - upto 16x Faster!

UUIDv7 in PostgreSQL: A new key approach - credativ®

That Guy From Delhi: Teaching Query Planner to See Inside C Functions

Postgresql and Timescale with RedHat VDO – Lisa's Home Page

Identifying and resolving performance issues caused by TOAST OID contention in Amazon Aurora PostgreSQL Compatible Edition and Amazon RDS for PostgreSQL | AWS Database Blog

What are SLRUs and MultiXacts in Postgres? What can go wrong? | Software Engineer, Author, High Performance PostgreSQL for Rails

History of improvements in VACUUM in PostgreSQL

pg_dphyp: teach PostgreSQL to JOIN tables in a different way - DEV Community

Analyzing PostgreSQL Performance Using Flame Graphs | Jan’s website and blog

Avoid UUID Version 4 Primary Keys | Software Engineer, Author, High Performance PostgreSQL for Rails

PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs - DEV Community

Big Problems From Big IN lists with Ruby on Rails and PostgreSQL | Software Engineer, Author, High Performance PostgreSQL for Rails

Split-brain in case of network partition · cloudnative-pg/cloudnative-pg · Discussion #7462 · GitHub

Debugging memory leaks in Postgres, heaptrack edition

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

The Wide World of GiST Indexes - Simple Talk

How Core Git Developers Configure Git

PostgreSQL planner development and debugging - DEV Community

Talking Postgres with Claire Giordano | Why mentor Postgres developers with Robert Haas

Some of My Favorite Things – Postgres Queries | 🛩️ Shane Borden's Technology Blog

Keyset Cursors, Not Offsets, for Postgres Pagination

MultiXacts in PostgreSQL: usage, side effects, and monitoring | AWS Database Blog

Speeding Up Foreign Key Constraints During Migrations

Talking Postgres with Claire Giordano | How I got started as a developer (& in Postgres) with Tom Lane

Rounding Numbers - Simple Talk

Postgres Planner Quirks: JOIN Equivalence Classes and IN/ANY filters

Uniqueness, Keys, and Identity - Simple Talk

What's New for Developer's in PostgreSQL 17

How to Get or Create in PostgreSQL | Haki Benita

Talking Postgres with Claire Giordano | How I got started as a developer (& in Postgres) with David Rowley

Keyset pagination with descending order

Synopsis of several compelling features in PostgreSQL 16 | AWS Database Blog

How authentication protocols work | NetworkRADIUS

GitHub - mnesarco/sqlpage_auth_example: SQLPage Authentication and Authorization example

https://versus.com

Reduce Vacuum by Using “ON CONFLICT” Directive | 🛩️ Shane Borden's Technology Blog

Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 1 – PL/pgSQL | Database and Migration Insights

22 Best Free and Open Source Linux Application Launchers - LinuxLinks

Default Sort Order in Db2, SQL Server, Oracle & Postgres 17 | Ardent Performance Computing

Open WebUI – Une interface graphique pour Ollama

cursor_tuple_fraction and PostgreSQL JDBC | CYBERTEC PostgreSQL | Services & Support

Transforming and Analyzing Data in PostgreSQL - Simple Talk

Waiting for Postgres 17: Faster B-Tree Index Scans for IN(...) lists and ANY =

Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3 - Simple Talk

Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2 - Simple Talk

Performance tuning: MAX and GROUP BY

Why CockroachDB doesn't use EvalPlanQual

Pagination Using window-functions (OVER)

A critique of ANSI SQL Isolation layers (Transaction Processing Book followup)

Pitfalls of using SELECT * - Stormatics

I lost my pg_control again (... yet another data recovery story)

SQL Logic - Simple Talk

Recovering Deleted Data From PostgreSQL Tables

Waiting for Postgres 17: The new built-in C.UTF-8 locale

Speed up PostgreSQL® pgvector queries with indexes | EverSQL

Less is More - CommandPrompt Inc.

Factcheck: What is the carbon footprint of streaming video on Netflix? - Carbon Brief

Eager Aggregation in SQL queries - Simple Talk

Speeding up partial COUNT(*) in Postgres by using LIMIT in a subquery

The Rest is History: Investigations of WAL... | Crunchy Data Blog

Benchmarking PostgreSQL connection poolers: PgBouncer, PgCat and Supavisor | Tembo

Out of range planner statistics and "get_actual_variable_range" in Postgres

What’s new in the Postgres 16 query planner / optimizer

Créer un index B-tree composé efficace, – Le blog Tech d'Indy

What's up in PostGIS today ?

Stockage physique, gestion des données et VACUUM – BazinGa's

Pseudonymiser vos bases PostgreSQL - Capdata TECH BLOG

Simulate sun shadows

How to partition Postgres tables by timestamp based UUIDs

ZLinky_TIC Antenne_externe Non

Zero downtime Postgres upgrades | Knock

Migrate date functions from Oracle to Amazon RDS for PostgreSQL | AWS Database Blog

Harnessing pg_vector for Building a Recommendation System in Postgres | by Syfe Tech | Jan, 2024 | Medium

How to Convert PostgreSQL Streaming Replication to Logical Replication

PostGIS Performance Tips

GitHub - jankapunkt/latexcv: :necktie: A collection of cv and resume templates written in LaTeX. Leave an issue if your language is not supported!

GitHub - dataegret/pg-utils: Useful PostgreSQL utilities

Unlock Your Arsenals: GDB Debugging Essentials with PostgreSQL - techbuddies.io

JSON Path Operator Confusion

pg_stat_io and PostgreSQL 16 performance

PostgreSQL EXPLAIN Glossary - pgMustard

Understanding EXPLAIN - part 1 - Costs and actual time | Louise Grandjonc, Python/SQL developer but also a human

GitHub - neondatabase/pg_embedding: Hierarchical Navigable Small World (HNSW) algorithm for vector similarity search in PostgreSQL

GitHub - lanterndata/lantern: PostgreSQL vector database extension for building AI applications

Postgres Performance Tuning, Part III: Optimizing Indexes

Timed wait events in PostgreSQL

When to Consider Postgres Partitioning

postgresql comprendre le fonctionnement du shared_buffer

Measuring the Memory Overhead of a Postgres Connection · Postgres From Below

Postgres memory allocation and OS memory allocation - DEV Community

HNSW Indexes with Postgres and pgvector

Manage case-insensitive data in PostgreSQL | AWS Database Blog

Database Concurrency in PostgreSQL - Simple Talk

FlameGraphs on Steroids with profiler.firefox.com - DEV Community

Chiffrement sous PostgreSQL : mais sous quelles conditions ? - Capdata TECH BLOG

Reproducible builds: a PostgreSQL query optimization example

Subqueries and performance in PostgreSQL - CYBERTEC

The GROUP BY Clause - Simple Talk

Memory context: how PostgreSQL allocates memory - CYBERTEC

Unexpected downsides of UUID keys in PostgreSQL - CYBERTEC

Postgres Partition Pains - LockManager Waits

High-compression Metrics Storage with Postgres Hyperloglog

GitHub - x4m/gist2023: Materials for PGCon-2023 talk "GiST news and prospects"

Logical Replication on Standbys in Postgres 16

ALTER DEFAULT PRIVILEGES in PostgreSQL - CYBERTEC

Unconventional ways to index UUIDs in PostgreSQL | Citus Con: An Event for Postgres 2023

Join order: how to force it in PostgreSQL - CYBERTEC

Investigate intermittent saturation of lock_manager lwlocks in main db replicas (#2301) · Issues · GitLab.com / GitLab Infrastructure Team / scalability · GitLab

Tracking HOT updates and tuning FillFactor with Prometheus and Grafana - Adyen

Fighting PostgreSQL write amplification with HOT updates - Adyen

Comment avoir plusieurs profils Git ? | vmaerten's blog

What performs better, SQL FILTER or CASE?

PostgreSQL Documentation: min_dynamic_shared_memory parameter

How PostgreSQL improved statistics collector in the latest version

Underscores in numeric constants in PostgreSQL 16 - CYBERTEC

PostgreSQL 16: EXPLAIN (GENERIC_PLAN) - CYBERTEC

GitHub - GuillaumeGomez/tuto-rust-fr: Un tutoriel pour apprendre Rust

Inside logical replication in PostgreSQL: How it works

Tout sur l’installation domotique de ma maison – Tech2Tech | News, Astuces, Tutos, Vidéos autour de l'informatique

Mr. Free Tools - The Best Free Tools & Resources

The Integer at the End of the Universe: Integer Overflow in Postgres

Postgres Raster Query Basics

How to migrate from Django’s PostgreSQL CI Fields to use a case-insensitive collation - Adam Johnson

Graphs in the Database: Rdbms In The Social Networks Age

Trees In The Database - Advanced data structures

PostgreSQL Basics: Object Ownership and Default Privileges - Simple Talk

Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io

Paris Web - Transferts de données : est-ce que je peux encore utiliser des fournisseurs américains ?

GitHub - cybertec-postgresql/pgfaceting: Faceted query acceleration for PostgreSQL using roaring bitmaps

PostgreSQL unique constraint, but NULL conflicts with everything

draft-ietf-uuidrev-rfc4122bis-01 - A Universally Unique IDentifier (UUID) URN Namespace

ULIDs and Primary Keys | Dave Allie

GitHub - mausimag/pgflake: A snowflake algorithm implemented as Postgres Extension.

PostgreSQL: Re: Weird planner issue on a standby

Intégrez vos produits SwitchBot à Home assistant - Devotics

GitHub - jnidzwetzki/pg-lock-tracer: A BPF based lock tracer for the PostgreSQL database

Debugging PostgreSQL CI failures faster: 4 tips - Microsoft Community Hub

hex, oct, bin integers in PostgreSQL 16

Improving GROUP BY with CREATE STATISTICS - CYBERTEC

Rethinking buffer mapping for modern hardware architectures

Pagination and the problem of the total result count - CYBERTEC

Using ULIDs at incident.io | Lawrence Jones

GitHub - epoupon/lms: Lightweight Music Server. Access your self-hosted music using a web interface.

GitHub - Koenkk/zigbee2mqtt: Zigbee 🐝 to MQTT bridge 🌉, get rid of your proprietary Zigbee bridges 🔨

Faceting large result sets in PostgreSQL

QOwnNotes

5mins of Postgres E45: IN lists vs ANY operator: Bind parameters and performance

Reducing replication lag with IO concurrency in Postgres 15 - Microsoft Community Hub

A PostgreSQL Developer's Perspective: Five Interesting Patches From September's Commitfest

New Public Schema Permissions in PostgreSQL 15

Harnessing Shared Buffers - Part 2

Be Ready! Public schema changes in Postgres 15

Postgres vs. File Systems: A Performance Comparison

Rails 7 adds Marginalia to Query Logs | Saeloun Blog

Harnessing Shared Buffers (and Reaping the Performance Benefits) - Part 1

GitHub - ihippik/tiny-driver: Yet another PostgreSQL driver

GitHub - kakoni/awesome-healthcare: Curated list of awesome open source healthcare software, libraries, tools and resources.

Test de Lixee Zlinky : La téléinformation en Zigbee avec Home Assistant et Jeedom

ESPHome — ESPHome

Rome2rio: discover how to get anywhere

Auto setup remote branch and never again see an error about the missing upstream | pawelgrzybek.com

GitHub - afiskon/postgresql-extensions: Experiments with PostgreSQL extensions

GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation

GitHub - johnkerl/miller: Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

Fixing Slow PostgreSQL Queries: How to Make a Smart Optimizer More Stupid

GitHub - mfvanek/pg-index-health-sql: pg-index-health-sql is a set of sql-queries for analyzing and maintaining indexes health in Postgresql databases.

PostgreSQL 15: Stats Collector Gone? What's New? - Percona Database Performance Blog

Rise of the Anti-Join

Column order in PostgreSQL does matter - CYBERTEC

Better SQL functions in PostgreSQL v14 - CYBERTEC

My Notes on GitLab Postgres Schema Design – Shekhar Gulati

GitHub - levkk/pgcat: PostgreSQL pooler with sharding, load balancing and failover support.

GitHub - agroal/pgagroal: High-performance connection pool for PostgreSQL

Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀 - DEV Community

Select the Most Recent Record (of Many Items) With PostgreSQL

Choosing a PostgreSQL Number Format

Pleasant debugging with GDB and DDD

Transaction anomalies with SELECT FOR UPDATE - CYBERTEC

Postgres Indexes, Selectivity, and Statistics

Common DB schema change mistakes | Database Lab · Instant clones of PostgreSQL databases · Postgres.ai

Creating a search catalog in PostgreSQL using full text indexing

Debugging deadlocks in PostgreSQL - CYBERTEC

Case-insensitive pattern matching in PostgreSQL - CYBERTEC

PostgreSQL at Scale: Database Schema Changes Without Downtime | by James Coleman | The PayPal Technology Blog | Medium

View permissions and row-level security in PostgreSQL - CYBERTEC

Improving Postgres Connection Scalability: Snapshots - Microsoft Tech Community

Analyzing the Limits of Connection Scalability in Postgres - Microsoft Tech Community

Talk - Anthony Shaw: Write faster Python! Common performance anti patterns

Cancel a hanging PostgreSQL query - CYBERTEC

Queries in PostgreSQL. Index scan / Habr

Postgres Query Optimization: LEFT JOIN vs UNION ALL

Speeding up sort performance in Postgres 15 - Microsoft Tech Community

5mins of Postgres E11: MERGE in Postgres 15, and how it compares to INSERT ON CONFLICT

SQLreduce: Reduce verbose SQL queries to minimal examples - credativ®

Time zone management in PostgreSQL - CYBERTEC

PostgreSQL 15: Using MERGE in SQL - CYBERTEC

Analyzing Postgres performance problems using perf and eBPF | Citus Con: An Event for Postgres 2022

Two-phase commits for logical replication publications/subscriptions

Multiranges in PostgreSQL 14 - | CYBERTEC Data Science & PostgreSQL

How Postgres Chooses Which Index To Use For A Query

Index Skip Scan in YugabyteDB 🚀🐘 - DEV Community

Queries in PostgreSQL. Sequential Scan / Habr

Amazon Aurora: Design Considerations + On Avoiding Distributed Consensus for I/Os, Commits, and Membership Changes

GitHub - mgramin/awesome-db-tools: Everything that makes working with databases easier

Queries in PostgreSQL: 2. Statistics : Postgres Professional

GitHub - jqnatividad/qsv: CSVs sliced, diced & analyzed.

GitHub - secretGeek/AwesomeCSV: 🕶️A curated list of awesome tools for dealing with CSV.

GitHub - dhamaniasad/awesome-postgres: A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

GitHub - awesome-selfhosted/awesome-selfhosted: A list of Free Software network services and web applications which can be hosted on your own servers

GitHub - BurntSushi/xsv: A fast CSV command line toolkit written in Rust.

Optimizing Postgres Text Search with Trigrams - Alex Klibisz

GitHub - juliojsb/sarviewer: Generate graphs with gnuplot or matplotlib (Python) from sar data

GitHub - mbaldessari/sarstats: Creates a PDF report out of sar files

GitHub - sargraph/sargraph.github.io: SARchart - An opensource version of the tool for viewing Unix SAR data as Charts/Graphs

Queries in PostgreSQL. Statistics / Habr

Logical Replication/Decoding Improvements in PostgreSQL 13 and 14 - Percona Database Performance Blog

SELECT FOR UPDATE and its behavior with foreign keys in PostgreSQL - MigOps

Queries in PostgreSQL: 1. Query execution stages

Data Normalization in PostgreSQL - CYBERTEC

Queries in PostgreSQL. Query execution stages / Habr

How to gain insight into the pg_stat_replication_slots view by examining logical replication

Practical Examples of Data Normalization in PostgreSQL - CYBERTEC

Migrating a PostgreSQL cluster managed by Patroni – Flant blog

Progress bar for Postgres queries – let's dive deeper | Database Lab · Instant clones of PostgreSQL databases · Postgres.ai

How Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster - Percona Database Performance Blog

Outil de calcul de revenus pour freelance et salariés | Eventually coding

Rails: Postgres Native Partitioning

Parallel Programming: December 2021 Update - Paul E. McKenney's Journal — LiveJournal

Time-series compression algorithms, explained

GitHub - 3liz/formation-postgis: Formation PostGIS pour les utilisateurs de QGIS

Locks in PostgreSQL: 4. Locks in memory / Habr

Manage encryption keys with PostgreSQL TDE - CYBERTEC

zheap UNDO logs discarding in PostgreSQL - CYBERTEC

Hands-on with PostgreSQL Authorization - Part 1 - Roles and Grants

Explore the new SEARCH and CYCLE features in PostgreSQL 14

Quick 📸 on 🐘 active SQL from pg_stat_statements - DEV Community

GitHub - kasaharatt/pg_rand_ext: An extension to provide some random value generation functions for PostgreSQL.

Tricks for Faster Spatial Indexes

Understanding Postgres GIN Indexes: The Good and the Bad

How did PostGIS get Fast(er)?

gitlab index contenant plein de dead tuples, impact sur les secondaires qui n'ont pas les killed tuples

PostgreSQL 14 and beyond

Improving PostgreSQL performance without making changes to PostgreSQL

Is Aurora PostgreSQL really faster and cheaper than RDS PostgreSQL - Benchmarking - MigOps

gitlab Investigate buffer_mapping contention issue from 2021-11-22 incident

What developers find surprising about Postgres transactions | Lawrence Jones

Installation de Frigate dans un LXC Proxmox

Lesser Known PostgreSQL Features | Haki Benita

GitHub - pikvm/pikvm: Open and cheap DIY IP-KVM based on Raspberry Pi

PostgreSQL 14’s enable_memoize For Improved Performance of Nested Loop Joins – Java, SQL and jOOQ.

GitHub - enova/pgl_ddl_deploy: Transparent Logical DDL Replication

Choice of Table Column Types and Order When Migrating to PostgreSQL

Les phoques au secours des baleines - À la découverte de Podman (Benjamin Vouillaume) - YouTube

А deep dive into PostgreSQL query optimizations : Postgres Professional

TCP keepalive for a better PostgreSQL experience - CYBERTEC

Database Security Best Practices on Kubernetes

GitHub - huachaohuang/awesome-dbdev: Awesome materials about database development.

GitHub - yingjunwu/DBMS-Indexology: A Collection of Papers on Database Index Structures

Postgres text search: balancing query time and relevancy

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance | Haki Benita

What is the new LZ4 TOAST compression in PostgreSQL 14, and how fast is it?

WITH HOLD cursors and transactions in PostgreSQL - CYBERTEC

Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database Lab · Fast clones of PostgreSQL databases · Postgres.ai

Herding elephants: Lessons learned from sharding Postgres at Notion

Rust : sûr et concurrent. Mais comment fait-il ? (Benjamin Coenen) - YouTube

In defence of swap: common misconceptions

Linux buffered write latency - DEV Community

Upgrading PostgreSQL 9.6 to PostgreSQL 13 - MigOps

Why we spent the last month eliminating PostgreSQL subtransactions|GitLab

Gaps in sequences in PostgreSQL, causes and remedies - CYBERTEC

JSON in PostgreSQL: how to use it right - CYBERTEC

How percentile approximation works (and why it's more useful than averages)

jsquery vs SQL/JSON | EDB

Fuzz your way to PostgreSQL (part 1)

A Rust PostgreSQL Extension for CAS Numbers | Depth-First

How to build a job queue with Rust and PostgreSQL

Postgres Extensions in Rust | Depth-First

Index bloat reduced in PostgreSQL v14 - Cybertec

Notes on some PostgreSQL implementation details

PostgreSQL Subtransactions and performance - Cybertec

PostgreSQL Subtransactions Considered Harmful | Database Lab · Fast clones of PostgreSQL databases · Postgres.ai

Container Runtimes : C'est quoi ?

GitHub - michelp/pgsodium: Modern cryptography for PostgreSQL using libsodium.

A UNIQUE experience - Simple Talk

Performance of Various EBS Storage Types in AWS - Percona Database Performance Blog

Postgres query execution: simple query - prepared statement - DEV Community

How PostgreSQL aggregation works

Locks in PostgreSQL: 1. Relation-level locks : Postgres Professional

Locks in PostgreSQL: 2. Row-level locks : Postgres Professional

Locks in PostgreSQL: 3. Other locks : Postgres Professional

Locks in PostgreSQL: 4. Locks in memory : Postgres Professional

INDEX / REINDEX progress report (PG12+)

Docker : découverte des bases - Code Heroes

GitHub - Networks-Learning/stackexchange-dump-to-postgres: Python scripts to import StackExchange data dump into Postgres DB.

GitHub - SkobelevIgor/stackexchange-xml-converter: Stackexchange (e.g., stackoverflow) data dump converter from XML to CSV format.

GitHub - niderhoff/nlp-datasets: Alphabetical list of free/public domain datasets with text data for use in Natural Language Processing (NLP)

GitHub - pemistahl/lingua-rs: 👄 The most accurate natural language detection library in the Rust ecosystem, suitable for long and short text alike

Supervision de SystemD avec systemd-cgtop | Commandes et Système | IT-Connect

Better Range Types in Postgres 14: Turning 100 Lines of SQL Into 3

GitHub - meilisearch/MeiliSearch: Lightning Fast, Ultra Relevant, and Typo-Tolerant Search Engine

GitHub - greyblake/whatlang-rs: Natural language detection library for Rust. Try demo online: https://whatlang.org/

WAL in PostgreSQL: 3. Checkpoint : Postgres Professional

Bring your own CI/CD.

GitHub - timClicks/pg_rot13: A PostgreSQL extension module to apply ROT13 to text

Enabling and disabling autovacuum in PostgreSQL | CYBERTEC

GitHub - plasma-umass/scalene: Scalene: a high-performance, high-precision CPU, GPU, and memory profiler for Python

The Volcano/Cascades Optimizer

From hours to seconds. SQL Query Optimization using Volcano | by Gaurav Sehgal | Medium

CrunchyData Interactive Learning Portal

sql - Does PostgreSQL support "accent insensitive" collations? - Stack Overflow

GitHub - ayazhafiz/xorf: Xor filters - efficient probabilistic hashsets. Faster and smaller than bloom and cuckoo filters.

How we made DISTINCT queries up to 8000x faster on PostgreSQL

Using PostgreSQL to Create an Efficient Search Engine - Alibaba Cloud Community

Creating a Read-Only Postgres User

GitHub - microsoft/SQL-ProcBench: SQL-ProcBench is an open benchmark for procedural workloads in RDBMSs.

(The Many) Spatial Indexes of PostGIS

Practical SQL for Data Analysis | Haki Benita

R CHARTS | A collection of charts and graphs made with the R programming language

Golang Code Examples

The Data School by Chartio

GitHub - KDE/heaptrack: A heap memory profiler for Linux

WAL in PostgreSQL: 2. Write-Ahead Log : Postgres Professional

How to set up Vim for Go Development | Preslav Mihaylov

GitHub - gperftools/gperftools: Main gperftools repository

GitHub - xwmx/nb: CLI plain-text note-taking, bookmarking, and archiving with encryption, filtering and search, Git-backed versioning and syncing, Pandoc-backed conversion, and more in a single portable script.

Spatial Indexing for OSM in PostGIS

WAL in PostgreSQL: 1. Buffer Cache

GitHub - microsoft/DataMigrationTeam: Repository for the Data Migration Team

Migrating database storage objects from Oracle to Postgres - Microsoft Tech Community

20 outils webs indispensables pour développeurs

Re-Introducing Hash Indexes in PostgreSQL | Haki Benita

Some SQL Tricks of an Application DBA | Haki Benita

GitHub - knadh/listmonk: High performance, self-hosted newsletter and mailing list manager with a modern dashboard. Go + VueJS.

Don't let collation versions corrupt your PostgreSQL indexes - Microsoft Tech Community

GitHub - sentriz/gonic: music streaming server / subsonic server API implementation

GitHub - hyrise/index_selection_evaluation: Platform to evaluate index selection algorithms

Indexes in PostgreSQL — 10 (Bloom) : Postgres Professional

Indexes in PostgreSQL — 9 (BRIN) : Postgres Professional

Indexes in PostgreSQL — 8 (RUM) : Postgres Professional

Use nconnect to effortlessly increase NFS performance | by Emily Potyraj (Watkins) | Aug, 2020 | Medium

Starship: Cross-Shell Prompt

GitHub - drduh/YubiKey-Guide: Guide to using YubiKey for GPG and SSH

GitHub - kryonix/pg_cuckoo: Use PostgreSQL's planner hook to open a side entrance through which we can pass plan trees for immediate execution

GitHub - vitabaks/pgbackrest_auto: pgbackrest_auto: Automatic Restore and Validate for physical and logical database corruption (PostgreSQL)

Parallelism in PostgreSQL: treatment of trees and conscience / Postgres Professional corporate blog / Habr

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

What is Baked in the Baker's Dozen? / Postgres Professional corporate blog / Habr

Crêpes de lentilles corail, oignons et blettes - La cuisine de Bernard

How io_uring and eBPF Will Revolutionize Programming in Linux - The New Stack

GitHub - deluan/navidrome: 🎧☁️Music Server and Streamer compatible with Subsonic/Airsonic

Sumner Evans / Sublime Music · GitLab

GitHub - spl0k/supysonic: Supysonic is a Python implementation of the Subsonic server API.

io_uring By Example: An Article Series - Unixism

GitHub - tycho/clockperf: clocksource behavior microbenchmarks

GitHub - home-assistant/home-assistant: Open source home automation that puts local control and privacy first

GitHub - jeedom/core: Software for home automation

GitHub - domoticz/domoticz: Open source Home Automation System

GitHub - BLAKE3-team/BLAKE3: The BLAKE3 cryptographic hash function

GitHub - KDAB/hotspot: The Linux perf GUI for performance analysis.

GitHub - ChenHuajun/pg_roaringbitmap: RoaringBitmap extension for PostgreSQL

GitHub - flier/gohs: GoLang Binding of HyperScan https://www.hyperscan.io/

GitHub - influxdata/tdigest: An implementation of Ted Dunning's t-digest in Go.

GitHub - DATA-DOG/go-sqlmock: Sql mock driver for golang to test database interactions

B-tree index improvements in PostgreSQL v12 - Cybertec

Modern Data Practice and the SQL Tradition | Florents Tselai

GitHub - rust-lang/rustlings: Small exercises to get you used to reading and writing Rust code!

GitHub - dgryski/go-perfbook: Thoughts on Go performance optimization

Transactions in PostgreSQL and other animals - Speaker Deck

Introduction · Buf

Courses - Carnegie Mellon Database Group

Common Go Pitfalls - Tyler Finethy - Medium

The SQL Murder Mystery

Instantaneous transaction rollback, and other advantages of versioned storage

GitHub - cfsamson/book-exploring-epoll-kqueue-iocp: Repository for the book Exploring Epoll, Kqueue and IOCP with Rust

GitHub - lfittl/pg_query_go: Go library to parse and normalize SQL queries using the PostgreSQL query parser

AMD EPYC Naples vs Rome and vSphere CPU Scheduler Updates - frankdenneman.nl

GitHub - golangci/golangci-lint: Linters Runner for Go. 5x faster than gometalinter. Nice colored output. Can report only new issues. Fewer false-positives. Yaml/toml config.

GitHub - vim-syntastic/syntastic: Syntax checking hacks for vim

GitHub - dense-analysis/ale: Check syntax in Vim asynchronously and fix files, with Language Server Protocol (LSP) support

GitHub - 360EntSecGroup-Skylar/goreporter: A Golang tool that does static analysis, unit testing, code review and generate code quality report.

Creating Custom Errors in Go | DigitalOcean

GitHub - keon/awesome-nlp: A curated list of resources dedicated to Natural Language Processing (NLP)

Evaluate Odyssey as a replacement for pgbouncer(s) (#7776) · Issues · GitLab.com / GitLab Infrastructure Team / infrastructure · GitLab

RCA: 2019-08-20 Elevated web latency (#7632) · Issues · GitLab.com / GitLab Infrastructure Team / infrastructure · GitLab

Linux Pressure Stall Information (PSI) by Example - Unixism

Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP - Cybertec

Using Docker Hub PostgreSQL images - 2ndQuadrant | PostgreSQL

Modeling Time - Simple Talk

History and effective use of Vim

Standby in production: scaling application in the second largest classified site in the world

Graceful upgrades in Go

Compiler Explorer

Go Sorting With the sort Package - Tutorial | TutorialEdge.net

PostgreSQL's indexes - GIN algorithms | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL's indexes - GIN | Louise Grandjonc, Python/SQL developer but also a human

GitHub - tidwall/evio: Fast event-loop networking for Go

A Million WebSockets and Go

Going Infinite, handling 1M websockets connections in Go - Speaker Deck

Indexes in PostgreSQL — 10 (Bloom) / Postgres Professional corporate blog / Habr

Go Memory Management Part 2 - Povilas Versockas

Release High Performance pgBackRest (PGCon 2019) · dwsteele/conference · GitHub

Parallel test execution in Go | Eleni Fragkiadaki

Intro to Postgres Planner Hacking

Indexes in PostgreSQL — 8 (RUM) / Postgres Professional corporate blog / Habr

Abusing SECURITY DEFINER functions - Cybertec

Go: Should I Use a Pointer instead of a Copy of my Struct?

Time complexity of array/list operations [Java, Python] · YourBasic

PostgreSQL v12 new feature: optimizer support for functions - Cybertec

Parlons de Linux eBPF, l’outil de «Tracing » surpuissant et indispensable ! (Jérémie Lagarde)

1-to-1 relationship in PostgreSQL for real - Cybertec

So You Wanna Go Fast? – Brave New Geek

SCALE 15x Minimizing PostgreSQL Major Version Upgrade Downtime

Index INCLUDE Clause: How it works and when to use it

Indexes in PostgreSQL — 7 (GIN) / Postgres Professional corporate blog / Habr

Indexes in PostgreSQL — 5 (GiST) / Postgres Professional corporate blog / Habr

Indexes in PostgreSQL — 6 (SP-GiST) / Postgres Professional corporate blog / Habr

DECLARE CURSOR in PostgreSQL or how to reduce memory consumption - Cybertec

Go Performance Observations | Hashrocket

The Difference Between SQL’s JOIN .. ON Clause and the Where Clause – Java, SQL and jOOQ.

Allocation efficiency in high-performance Go services · Segment Blog

SQL Query Optimization for Large IN Queries – Mukul Chaware – Medium

GitHub - laowantong/mocodo: Modélisation Conceptuelle de Données. Nickel. Ni souris.

WTF is Big O Notation? – Rob Conery

Indexes in PostgreSQL — 4 (Btree) / Postgres Professional corporate blog / Habr

PostgreSQL - Haute disponibilité avec Patroni

Calculating Weighted Averages When Joining Tables in SQL – Java, SQL and jOOQ.

Debugging the Postgres query planner — GoCardless Blog

The art of writing eBPF programs: a primer. |Sysdig

pgBackRest - Performing Backups on a Standby Cluster

Exclusive backup method is deprecated - what now? - Cybertec

Parallel queries in PostgreSQL - Percona Database Performance Blog

YOW2018 Cloud Performance Root Cause Analysis at Netflix

Pub-Sub avec Postgres

GitHub - pjungwir/postgres-temporal-talk: My talk about Postgres and Temporal Databases

AMD EPYC and vSphere vNUMA - frankdenneman.nl

WITH Queries: Present & Future

plprofiler - Getting a Handy Tool for Profiling Your PL/pgSQL Code - Percona Database Performance Blog

PostgreSQL 11 Reestablishes Window Functions Leadership

How to Calculate a Cumulative Percentage in SQL – Java, SQL and jOOQ.

PostgreSQL Deep Dive: How Your Data Model Affects Storage

PostgreSQL: [PATCH] Equivalence Class Filters

PostgreSQL: Equivalence Classes when using IN

Transparent Data Encryptoin in PostgreSQL and Integratino with Key Ma…

How to Emulate PERCENTILE_DISC in MySQL and Other RDBMS – Java, SQL and jOOQ.

Calculate Percentiles to Learn About Data Set Skew in SQL – Java, SQL and jOOQ.

COUNT(*) vs COUNT(1) vs COUNT(id) – Alexey Bashtanov PostgreSQL Blog

GitHub - petergeoghegan/benchmarksql: Unofficial mirror of BenchmarkSQL PostgreSQL TPC-C fair-use implementation

GitHub - hjacobs/kubernetes-failure-stories: Compilation of public failure/horror stories related to Kubernetes

90 days of AWS EKS in Production - kubedex.com

Tagging Trillions of Users in Milliseconds with varbitx on PostgreSQL

GitHub - stressapptest/stressapptest: Stressful Application Test - userspace memory and IO test

GitHub - kostiantyn-nemchenko/ansible-role-patroni: Ansible Role for Patroni

GitHub - kubernetes-sigs/kubespray: Deploy a Production Ready Kubernetes Cluster

Containers, VMs... Comment ces technologies fonctionnent et comment les différencier? (Quentin Adam)

How does Clever Cloud work? (Clément Delafargue - Quentin Adam)

GitHub - nathanaelkane/vim-indent-guides: A Vim plugin for visually displaying indent levels in code

GitHub - thiagoalessio/rainbow_levels.vim: A different approach to code highlighting.

PG Phriday: PgBouncer or Bust | The Importance of Proxies

Empty Thoughts: Working with NULL - Simple Talk

PostgreSQL Updatable Views: Performing Schema Updates With Minimal Downtime - Percona Database Performance Blog

Bring native psql magic into Jupyter Notebook – Constantinos Antzakas – Medium

PG 11 Partitioning Optimization Features · GitHub

GitHub - erthalion/postgres-bcc

Using Ansible to bring up a three node Patroni cluster in minutes - Blog dbi services

A Primer on Database Replication

How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage | Haki Benita

Ma toolbox personnelle

Unearthing some hidden PostgreSQL 11 gems - Cybertec

GitHub - Percona-Lab/tpce-mysql

Linux Performance in Cloud: Exploring NUMA on Amazon Cloud Instances

GitHub - buger/goreplay: GoReplay is an open-source tool for capturing and replaying live HTTP traffic into a test environment in order to continuously test your system with real data. It can be used to increase confidence in code deployments, configuration changes and infrastructure changes.

Benchmark PostgreSQL With Linux HugePages - Percona Database Performance Blog

A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL" - Cybertec

PostgreSQL major version upgrade using built in Logical Replication

Architecture & Pitfalls of Logical Replication

What the SQL?! JOIN me at UNION Station

Managing Stateful Apps with the Operator Pattern; Orchestration Considerations · Pivotal Engineering Journal 4/4

Storing Stateful Data that Outlives a Container or a Cluster; Optimizing for Local Volumes · Pivotal Engineering Journal 3/4

Provisioning Stateful Kubernetes Containers that Work Hard and Stay Alive · Pivotal Engineering Journal 2/4

Stateful Apps in Kubernetes · Pivotal Engineering Journal 1/4

Bloat and Fragmentation in PostgreSQL

GitHub - AmatanHead/psql-hooks: Unofficial documentation for PostgreSQL hooks.

prepared transactions and their dangers - Cybertec

AWS re:Invent 2018: [REPEAT 1] Deep Dive on Amazon Aurora with PostgreSQL Compatibility (DAT305-R1)

Introducing Patroni as the Postgres Failover Manager on GitLab.com | GitLab

Evaluating High Availability Solutions for TimescaleDB + PostgreSQL

Databases vs. encryption |

Déployez vos machines virtuelles KVM sur Proxmox VE avec Cloud-Init

Power vs Performance · HewlettPackard/LinuxKI Wiki · GitHub

Why the RDBMS is the future of distributed databases, ft. Postgres and Citus

Adjusting maintenance_work_mem - Cybertec

Managing High Availability in PostgreSQL — Part I – Kristi Anderson – Medium

Transactions in PostgreSQL: READ COMMITTED vs. REPEATABLE READ - Cybertec

Sequential UUID Generators |

How to Aggregate an Archive Log’s Deltas into a Snapshot with SQL – Java, SQL and jOOQ.

PostgresSQL: Implicit vs. explicit joins - Cybertec

Postgres 11 partitioning | Denish Patel

PGDay UK 2016 -- Performace for queries with grouping

On the benefits of sorted paths |

Column And Table Redefinition With Minimal Locking | Ardent Performance Computing

enix.io - Il est lent ton réseau, GRO

Killed index tuples - a little known performance feature - Cybertec

PostgreSQL locking, part 3: lightweight locks - Percona Database Performance Blog

PostgreSQL locking, part 2: heavyweight locks - Percona Database Performance Blog

PostgreSQL locking, Part 1: Row Locks - Percona Database Performance Blog

PostgreSQL 11: Partitioning Evolution from Postgres 9.6 to 11 |

https://content.pivotal.io/white-papers/orca-a-modular-query-optimizer-architecture-for-big-data

Chewbii.com

Double negative and query performance – Alexey Bashtanov PostgreSQL Blog

Scaling Connections in Postgres

The Art of Database Experiments – PostgresConf Silicon Valley 2018 / …

Ideas for scaling PostgreSQL to multi-terabyte and beyond - Cybertec

CMP310_Deep Dive on Amazon EBS

CMP301_Deep Dive on Amazon EC2 Instances

CMP315_Optimizing Network Performance for Amazon EC2 Instances

DAT302_Deep Dive on Amazon Relational Database Service (RDS)

Mastering Kubernetes on AWS - CON308 - re:Invent 2017

Migrating Massive Databases and Data Warehouses to the Cloud - ENT327…

How Netflix Tunes Amazon EC2 Instances for Performance - CMP325 - re:…

NEW LAUNCH! Amazon EC2 Bare Metal Instances - CMP330 - re:Invent 2017

eVOL Monkey: AWS Aurora Postgres, not a great first impression

Amazon Aurora Postgres: First thoughts

PostgreSQL on AWS: Tips & Tricks (and horror stories)

Deep Dive on the Amazon Aurora PostgreSQL-compatible Edition - DAT402… - AWS Reinvent 2017

SRV318 Running Kubernetes with Amazon EKS - AWS Summit 2018

SRV321 Deep Dive on Amazon EBS - AWS Summit 2018

SRV319 Amazon EC2 Foundations - AWS Summit 2018

SRV310 Optimizing Relational Databases on AWS: Deep Dive on Amazon R… - AWS Summit 2018

SRV308 Deep Dive on Amazon Aurora - AWS Summit 2018

Part II – Playing around with Linux perf events and Flame Graphs on PostgreSQL – The little things about databases….

Won’t You Be My Neighbor? Quickly Finding Who is Nearby

Debugging the Postgres Planner

2018-10-04 Meetup PG Nantes - PostgreSQL: Estimer la mémoire nécessai…

Parallelism and Partitioning - Improvements in Postgres 11 | EnterpriseDB

Bloom index for bigint - ...

pgCenter - stress free Postgres stats.

Sequence Caching: Oracle vs. PostgreSQL

Optimizing web servers for high throughput and low latency | Dropbox Tech Blog

5x Faster Spatial Join with this One Weird Trick · Paul Ramsey

What is the “(scanning)” variant of a loose index scan? | MySQL Server Blog

Fetch First Rows Just Got Faster | Oracle Optimizer Blog

How to Use SQL UPDATE .. RETURNING to Run DML More Efficiently – Java, SQL and jOOQ.

Part I – Playing around with Linux perf events and Flame Graphs on PostgreSQL – The little things about databases….

A history lesson on SQL joins (in Postgres)

Running a database on EC2? Your clock could be slowing you down.

How to Write a Multiplication Aggregate Function in SQL – Java, SQL and jOOQ.

How to Reduce Syntactic Overhead Using the SQL WINDOW Clause – Java, SQL and jOOQ.

Hypothetical Partitioning for PostgreSQL

Correlation of PostgreSQL columns explained - Cybertec

Why Covering Indexes Are Incredibly Helpful

postgresql - pg_column_size reports different vastly sizes for table.* than specific columns - Stack Overflow

A first look at Amazon Aurora with MySQL/PostgreSQL compatibility – Benefits and Drawbacks – Part I

PostgreSQL 11 and Just In Time Compilation of Queries

Parallel PostGIS and PgSQL 11 · Paul Ramsey

Parallelism in PostgreSQL 11 - Speaker Deck

Bloat in PostgreSQL: A Taxonomy

Introduction to PostgreSQL's indexes | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL's indexes – BTrees internal data structure | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL's indexes - BTrees algorithms | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL: Re: [PATCH] Incremental sort (was: PoC: Partial sort)

GitHub - metacloud/molecule: Molecule aids in the development and testing of Ansible roles.

Find the Next Non-NULL Row in a Series With SQL – Java, SQL and jOOQ.

PostgreSQL: Parallel CREATE INDEX for better performance - Cybertec

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part Three - CrateDB

What hot_standby_feedback in PostgreSQL really does - Cybertec

Understanding System Columns in PostgreSQL | Severalnines

What’s new in MariaDB 10.3

Transactional Data Operations in PostgreSQL Using Common Table Expressions – Rob Conery

Synthetic Data Blog | Tonic

PostgreSQL: Re: ALTER TABLE .. SET STATISTICS

SQL vs. Flux: Choosing the right query language for time-series data

Designing the most performant Row Level Security strategy in Postgres

GitHub - avito-tech/pg_reindex: Reindexing PostgreSQL databases

Ask TOM "IN & EXISTS"

Uniting SQL and NoSQL for Monitoring: Why PostgreSQL is the ultimate data store for Prometheus

How SQL DISTINCT and ORDER BY are Related – Java, SQL and jOOQ.

GitHub - oltpbenchmark/oltpbench: Database Benchmarking Framework

Audit logging with Postgres partitioning | Denish Patel

How to store dates and times in PostgreSQL? – The system is the asset, code a liability – Medium

PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses – Java, SQL and jOOQ.

rules vs. trigger performance when logging bulk updates - Cybertec

PostgreSQL + Linux Kernel = Friendship - Speaker Deck

PostgreSQL for Beginners : Postgres Professional

PostgreSQL 10 – How to create a partitioned table based on JSONB column field value – The little things about databases….

pg_prefaulter: Scaling WAL Performance

Scaling PostgreSQL with PgBouncer: You May Need a Connection Pooler Sooner Than You Expect - Percona Database Performance Blog

Faster Point In Time Recovery (PITR) in PostgreSQL Using a Delayed Standby - Percona Database Performance Blog

Serment d'Hippocrate pour Data Scientist

Pg11 pgday 2018

Introduction to Data Vault Modeling

Default Partition - Adopting the Odds | EnterpriseDB

Optimizing queries on TimescaleDB hypertables with thousands of partitions

Fun with SQL: Functions in Postgres

Missing Data - Simple Talk

GitHub - djrobstep/migra: Like diff but for PostgreSQL schemas

Scalable incremental data aggregation on Postgres and Citus

Configuring memory for Postgres

Index creation can make SELECT performance worse - Cybertec

Faire société : le choix des coopératives - La Manufacture coopérative

Recovery use cases for Logical Replication in PostgreSQL 10

More on Postgres trigger performance - Cybertec

Using with Hugo · gnab/remark Wiki · GitHub

Measure the impact of DRBD on your PostgreSQL database thanks to pgio (the SLOB method for PostgreSQL) – bdt's blog

Fun with SQL: Window functions in Postgres

Data Egret: Autovacuum slides from PgCon 2018 Ottawa

Index skip scan | Oracle Scratchpad

CREATE VIEW vs. ALTER TABLE in PostgreSQL - Cybertec

GitHub - yandex/odyssey: Scalable PostgreSQL connection pooler

PostgreSQL: Detecting periods of activity in a timeseries - Cybertec

Showdown: MySQL 8 vs PostgreSQL 10

DeepL Traducteur

Peter Geoghegan's blog: Visualizing a column's space overhead using pg_hexedit

Preparing your multi-tenant app for scale

Are triggers really that slow in Postgres? - Cybertec

Using Go as a scripting language in Linux

cgroups to limit PostgreSQL resource usage on Linux - Cybertec

Row Movement Across PostgreSQL Partitions Made Easy | EnterpriseDB

Fun with SQL: Recursive CTEs in Postgres

Selecting all Columns Except One in PostgreSQL – Java, SQL and jOOQ.

Unit testing functions in PostgreSQL with pgTAP in 5 simple steps

avoid OR for better PostgreSQL query performance - Cybertec

Switchover/Switchback in PostgreSQL 9.3 | EnterpriseDB

PostgreSQL: Sharing data across function calls - Cybertec

Atelier Initiation au langage Go

Golang soyez plus fort que le garbage collector grâce l'escape analysis (B. Coenen, F. Samin)

Quand je serai grand je monterai une équipe full remote ! (Y. Brissaud)

Prise de décisions asynchrone, pourquoi et comment? (B. Delacrétaz)

SERIALIZABLE in PostgreSQL 11... and beyond

The Logical Disaster of Null – Rob Conery

Severe site degradation due to database load - Google Docs

Tech preview: PostgreSQL 11 - CREATE PROCEDURE - Cybertec

Why Auto Increment Is A Terrible Idea - Clever Cloud Blog

How does Stack Overflow do pagination? - Meta Stack Overflow

Data Egret: Let’s speed things up.

xmax, its various meanings and how to tell them apart - Cybertec

NoSQL best practices for PostgreSQL // Speaker Deck

Managing PostgreSQL clusters with Patroni // Speaker Deck

What’s New in MySQL 8.0? (Generally Available) | MySQL Server Blog

Effects of CPU caches – Nicolas Douillet – Medium

index maintenance - Get rid of your unused indexes! - Cybertec

Postgres 10 Upgrade

Advanced SQL: Why first_value and last_value are no bugs - Cybertec

Être une entreprise libérée, tu sais c’est pas si facile…

How Partial Indexes Affect UPDATE Performance in Postgres

pgcompacttable is a tool for reducing size of bloated tables and indexes without heavy locks.

GitHub - dataegret/pg-utils: Useful PostgreSQL utilities

Database constraints in Postgres: The last line of defense

PostgreSQL: Speeding up analytics and windowing functions

create-statistics-talk/create-statistics-what-is-it.pdf at master · tvondra/create-statistics-talk · GitHub

Using pg_badplan to CREATE STATISTICS is a good plan | Joel on SQL

Repeatable Read Is Not Repeatable – Database Journal Club – Medium

SQL/JSON standard-2016 conformance for PostgreSQL, Oracle, SQL Server and MySQL - ...

Updating a 50 terabyte PostgreSQL database – Adyen Tech – Medium

Three reasons why VACUUM won't remove dead rows from a table - Cybertec

Fuzz your way to PostgreSQL (part 2)

The Postgres 10 feature you didn't know about: CREATE STATISTICS

New features for sequences: gains and pitfalls - Cybertec

Fsync Performance on Storage Devices - Percona Database Performance Blog

Database migrations and Pum

When Postgres blocks: 7 tips for dealing with locks

Range Types & Recursion: How to Search Availability with PostgreSQL

PostgreSQL performance: How the optimizer handles views

Dix choses faisable qu'avec GDB

GitHub - gavinwahl/postgres-json-schema: JSON Schema validation for PostgreSQL

GitHub - ossc-db/pg_store_plans: Store execution plans like pg_stat_statements does for queries.

GitHub - ossc-db/pg_dbms_stats: Let PostgreSQL to make execution plans using frozen statistics.

Avoiding unnecessary stored procedure calls in PostgreSQL

Principles and Applications of the Index Types Supported by PostgreSQL

Degree of Duplication - Simple Talk

Le management participatif facteur de performance économique et sociale : A quelles conditions ? Eléments de réponse à partir du cas des Scop

Using plantuner for debugging indexes in PostgreSQL - ...

Data Egret: PostgreSQL Performance Meltdown?

CMU 15-445/645 :: Intro to Database Systems (Fall 2017)

CMU 15-721 :: Advanced Database Systems (Spring 2017)

Write Skew: Parallel Hash for PostgreSQL

How to Do Code Reviews Like a Human (Part One) - Silly Bits

Peter Geoghegan's blog: Exploring SP-GiST and BRIN indexes visually using pg_hexedit

Decrypting PgBouncer’s Diagnostic Information - Heap Blog

SQL Keys in Depth

Validation, Verification, and Modification - Simple Talk

PostgreSQL: How to speed up GROUP BY and joins

Visualize PostgreSQL index file with pgdfv – bdt's blog

PGConf EU: HyperLogLog, Eclipse, and Distributed Postgres

Indexing with Postgres: When Less is More – PlanGrid Technology – Medium

MySQL 8.0: Query Optimizer Takes Data Buffering into Account | MySQL Server Blog

Adding a NOT NULL CONSTRAINT on PG Faster with Minimal Locking

http://shiroyasha.io/transaction-isolation-levels-in-postgresql.html

Peter Geoghegan's blog: pg_hexedit: Rich hex editor annotations for Postgres relfiles

Free json datasets - ...

Advisory Locks and How to Use Them - Shiroyasha

How do UPSERT and MERGE work in Oracle, SQL Server, PostgreSQL and MySQL | Vlad Mihalcea's Blog

Your options for partitioning in PostgreSQL 10, explained

Parallel PostGIS IIA · Paul Ramsey

How to Avoid Excessive Sorts in Window Functions – Java, SQL and jOOQ.

Faster bulk loading in Postgres with copy

Data Egret: Deep dive into Postgres stats: pg_stat_progress_vacuum

Parallel PostGIS II · Paul Ramsey

Sql Antipatterns Strike Back

Learning w/ Diagrams: Handling Contention with PostgreSQL

PostgreSQL Domain Integrity In Depth

GitHub - w0rp/ale: Asynchronous Lint Engine

Data Egret: Deep dive into postgres stats: pg_stat_activity and pg_locks.

Vim After 15 Years | Ian Langworth’s Things of Variable Interest

A tour of Postgres Index Types

Gérer ses dotfiles simplement avec git // /home/lord

Data Egret: PostgreSQL's transition relations.

GitHub - jarulraj/sqlcheck: Automatically identify anti-patterns in SQL queries

GitHub - dmtolpeko/sqlines: SQLines SQL Converter

On Disk IO, Part 4: B-Trees and RUM Conjecture – αλεx π – Medium

On Disk IO, Part 3: LSM Trees – αλεx π – Medium

On Disk IO, Part 2: More Flavours of IO – αλεx π – Medium

On Disk IO, Part 1: Flavours of IO – αλεx π – Medium

GitHub - pgMemento/pgMemento: Audit trail with schema versioning for PostgreSQL using transaction-based logging

Fermi Estimates On Postgres Performance

10 Cool SQL Optimisations That do not Depend on the Cost Model – Java, SQL and jOOQ.

Partition-wise join | Learning is not a spectator sport

How does Postgres work? – Divya Nagar – Medium

How to Write Efficient TOP N Queries in SQL – Java, SQL and jOOQ.

How Citus works (a look at dynamic executors)

Virtual Machine vCPU and vNUMA Rightsizing - Rules of Thumb - VMware VROOM! Blog - VMware Blogs

Migrating from RethinkDB to Postgres — An Experience Report

ORACLE-BASE - Filtered Partition Maintenance Operations in Oracle Database 12c Release 2 (12.2)

LXC 2.1 has been released - News - Linux Containers Forum

Speeding up creation of PostgreSQL replicas

ORACLE-BASE - Partitioned External Tables in Oracle Database 12c Release 2 (12.2)

ORACLE-BASE - Read-Only Partitions and Subpartitions in Oracle Database 12c Release 2 (12.2)

ORACLE-BASE - Multi-Column List Partitioning in Oracle Database 12c Release 2 (12.2)

Tutoriel Vidéo Linux Configuration d'i3wm

Missing Data - Joe Celko

Data Egret: PostgreSQL workings in one picture.

Citus 7: Transactions, Framework Integration, and Postgres 10

Postgres Pro Standard : Documentation: 9.6: Appendix L. Demo Database “Airlines” : Postgres Professional

Visualizing data in PostgreSQL with R Shiny

JOIN Elimination: An Essential Optimiser Feature for Advanced SQL Usage – Java, SQL and jOOQ.

Databases and Distributed Deadlocks: A FAQ

SQL Code Smells - Simple Talk

Hacking PostgreSQL: Data Access Methods | edX

Deferrable SQL Constraints in Depth

ORACLE-BASE - Optimizer Statistics Advisor in Oracle Database 12c Release 2 (12.2)

Why is My Database Application so Slow? - Simple Talk

Autovacuum wraparound protection in PostgreSQL

Coopérer entre collègues, la solution pour ne plus souffrir au travail

Postgres vs. Oracle access paths VII - Bitmap Index Scan - Blog dbi services

Star Transformation | Oracle Scratchpad

Configurer l'ipv6 chez Online.net

GitHub - outime/ipv6-dhclient-script: IPv6 w/ dhclient configuration script (Debian/RedHat-based distros)

How to setup ipv6 with online.net dedi – Debian – Study and Life in Germany

Simple SQL: Random Thoughts - Joe Celko

Principles of Sharding for Relational Databases

9 Reasons Why There Are No Foreign Keys in Your Database (Referential Integrity Checks)

Experimenting with scaling and full parallelism in PostgreSQL

Practical Guide to SQL Transaction Isolation

Re: any way to get rid of Bitmap Heap Scan recheck?

Sysdig | Container isolation gone wrong

When To Avoid JSONB In A PostgreSQL Schema - Heap Blog

12 Things Developers Will Love About Oracle Database 12c Release 2 | Oracle All Things SQL Blog

https://www.slideshare.net/morgo/mysql-80-optimizer-guide

Average response time with Postgres’ Window Functions and CTEs

GitHub - martingms/vipsql: A vim-frontend for interacting with psql

18+ Best Online Resources for Learning SQL and Database Concepts

Data in Motion and Data at Rest - Simple Talk - Joe Celko

Writing your own aggregation functions

pg_dirtyread: Read dead but unvacuumed tuples from a PostgreSQL relation

PostgreSQL: Indexes and foreign keys

Analytics Playbook: Log Tables – Fishtown Analytics

SQL Data Aggregation Aggravation - Simple Talk - Joe Celko

Customizing My Postgres Shell

10 Common Data Structures Explained with Videos + Exercises

hotspot - a GUI for the Linux perf profiler - KDAB

Understanding vNUMA in vSphere – The Wifi-Cable

Playing with Unicode

Efficient rollup tables with HyperLogLog in Postgres

The File Layout of Postgres Tables | malisper.me

PostgreSQL 10 Beta vs PostgreSQL 9.6 Analytics Performance

Le piratage de TV5 Monde vu de l’intérieur

[Kernel] Interruptions et tasklets « Christophe Blaess

Measurements, scales and encoding schemes - Joe Celko

NVME PCIe 10GB/s KaiGai

Simple SQL: Attribute Splitting - Simple Talk - Joe Celko

PostgreSQL Conference - Moving PostgreSQL Forward

PostgreSQL Conference - Speeding up Query Execution

PostgreSQL Conference - POWER Platform - The New Home For PostgreSQL

PostgreSQL Conference - Sort vs. Hash: A Duality

PostgreSQL Conference - In-core compression: how to shrink your database size in several times

PostgreSQL Conference - Transitioning from MSSQL to PostgreSQL, our trails and tribulations.

PostgreSQL Conference - Schema management with Flyway

PostgreSQL Conference - Logical Replication in PostgreSQL 10

PostgreSQL Conference - Jsonb in Postgres - the present and future

PostgreSQL Conference - Processing 1 billion rows per second

PostgreSQL Conference - Next-Generation Parallel Query

PostgreSQL Conference - Migrating to PostgreSQL: Lessons Learned

PostgreSQL Conference - TOASTing an Elephant : Building a Custom Data Warehouse Using PostgreSQL

PostgreSQL Conference - How Green Was My Valley

How Basic Performance Analysis Saved Us Millions - Heap Blog

How to Generate at Least One Row in SQL – Java, SQL and jOOQ.

Some Great Things about PostgreSQL · Paul Ramsey

PostgreSQL and tablespaces - it's not so scary

PGStrom - GTC2017 - KaiGai

Lotechnica

Data Egret: Deep dive into postgres stats: pg_stat_user_indexes

SQL is 43 years old - here’s 8 reasons we still use it today | The Official SQLizer Blog

Using R Analytic Functions in PostGIS

Why favor PostgreSQL over MariaDB / MySQL

int4 vs int8 vs uuid vs numeric performance on bigger joins

Data Egret: Deep dive into postgres stats: pg_stat_all_tables

How to Calculate Multiple Aggregate Functions in a Single Query – Java, SQL and jOOQ.

How do PostgreSQL advisory locks work | Vlad Mihalcea's Blog

Removing duplicate rows in PostgreSQL

Slides "NoSQL Postgres" - ...

(func()).* - Hidden performance issues

Preprocessing Data for Spatial Analysis with PostGIS and PL/R

Spatial Analytics with PostGIS, PL/R and R

L'entropie sous Linux et la génération de nombres aléatoires

SQL/JSON in PostgreSQL is online now - ...

Data Egret: Deep dive into postgres stats: pg_stat_replication

Full-Text Search of JSON[b] data in PostgreSQL - ...

Distributed count(distinct) with HLL on Postgres | Citus Data

How to query JSONB, beginner sheet cheat – Hacker Noon

Linux block I/O tracing

Performance analysis in Linux

Greg Law " Give me 15 minutes & I'll change your view of GDB"

Debugging With GDB

Json in Postgres - The present and Future - ...

SQL IN Predicate: With IN List or With Array? Which is Faster? – Java, SQL and jOOQ.

Apprendre les bases de données et SQL

How to Benchmark Alternative SQL Queries to Find the Fastest Query – Java, SQL and jOOQ.

Data Egret: Deep dive into postgres stats: pg_stat_bgwriter reports

La puissance des workflows git – OVH UX Labs – Medium

Faster SQL Through Occasionally Choosing Natural Keys Over Surrogate Keys – Java, SQL and jOOQ.

IPv6 sur Dedibox par dhclient

PostgreSQL and Databases in general: Hash indexes are faster than Btree indexes?

Wildcard query for jsonb - ...

Impress Your Coworkers With the Incredible NATURAL FULL OUTER JOIN! – Java, SQL and jOOQ.

Data Egret: Deep dive into postgres stats: pg_stat_bgwriter

How the Kernel Manages Your Memory - Gustavo Duarte

Anatomy of a Program in Memory - Gustavo Duarte

Getting Physical With Memory - Gustavo Duarte

Memory Translation and Segmentation - Gustavo Duarte

Cache: A Place for Concealment and Safekeeping - Gustavo Duarte

What Your Computer Does While You Wait - Gustavo Duarte

Benchmark on a Parallel Processing Monster! |

Data Egret: Deep dive into postgres stats: pg_stat_database

PostgreSQL and RAM usage

Mastering Git — Why Rebase is amazing – Hacker Noon

GitHub - rickbergfalk/sqlpad: Web-based SQL editor run in your own private cloud. Supports MySQL, Postgres, SQL Server, Vertica, Crate, and Presto.

GitHub - airbnb/superset: Superset is a data exploration platform designed to be visual, intuitive, and interactive

GitHub - metabase/metabase: The simplest, fastest way to get business intelligence and analytics to everyone in your company

GitHub - getredash/redash: Make Your Company Data Driven. Connect to any data source, easily visualize and share your data.

PostgreSQL Internals (1) for PostgreSQL 9.6 (English)

Why You Should Design Your Database to Optimise for Statistics – Java, SQL and jOOQ.

PostgreSQL-Consulting.com: Deep dive into postgres stats: Introduction

PostgreSQL at 10 TB and beyond

Postmortem of database outage of January 31 | GitLab

A Probably Incomplete, Comprehensive Guide to the Many Different Ways to JOIN Tables in SQL – Java, SQL and jOOQ.

Git : Apprendre à utiliser le gestionnaire de versions pour ses projets

PostgreSQL's Powerful New Join Type: LATERAL - Heap Blog

psqlrc : psql startup file for postgres

Créer et utiliser des conteneurs LXC avec l’inventaire in-memory d’Ansible | Objectif Libre