Anayrat links

Production query plans without production data | boringSQL

March 9, 2026 at 10:02:49 AM GMT+1 * · permalink

https://boringsql.com/posts/portable-stats/

Free, IPv6 et OPNsense | Richard Dern

IPv6

March 5, 2026 at 11:44:47 PM GMT+1 * · permalink

https://richard-dern.fr/interets/informatique/2026/03/04/free-ipv6-et-opnsense/

https://www.cybertec-postgresql.com/en/insert-on-conflict-do-select-a-new-feature-in-postgresql-v19/

PostgreSQL · _on_conflict · UPSERT · pg19

March 4, 2026 at 1:54:59 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/insert-on-conflict-do-select-a-new-feature-in-postgresql-v19/

Postgres Locks Explained

PostgreSQL · lock · pg_locks

February 27, 2026 at 10:44:09 PM GMT+1 * · permalink

https://postgreslocksexplained.com/

PostgreSQL Statistics: Why queries run slow | boringSQL

PostgreSQL · Statistics

February 27, 2026 at 11:09:09 AM GMT+1 * · permalink

https://boringsql.com/posts/postgresql-statistics/

Row Locks With Joins Can Produce Surprising Results in PostgreSQL | Haki Benita

PostgreSQL · not_read · lock

February 24, 2026 at 9:40:16 PM GMT+1 * · permalink

https://hakibenita.com/postgres-row-lock-with-join

Create your PostgreSQL clusters with the "builtin" C collation!

PostgreSQL · Collation

February 24, 2026 at 9:39:59 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/c-collation-best-for-postgresql-clusters/

Tuning OpenZFS

ZFS

February 24, 2026 at 4:16:27 PM GMT+1 * · permalink

https://www.usenix.org/system/files/login/articles/login_winter16_09_jude.pdf

Everything I've seen on optimizing Postgres on ZFS

ZFS · PostgreSQL

February 24, 2026 at 4:11:06 PM GMT+1 * · permalink

https://vadosware.io/post/everything-ive-seen-on-optimizing-postgres-on-zfs-on-linux/#setting-logbiaslatency-instead-of-logbiasthroughput

PostgreSQL and ZFS filesystem

ZFS · EBS

February 24, 2026 at 4:10:14 PM GMT+1 * · permalink

https://bun.uptrace.dev/postgres/tuning-zfs-aws-ebs.html

Documentations du Groupe de Travail ZFS — Documentation GT-ZFS Documentation

ZFS

February 24, 2026 at 3:53:40 PM GMT+1 * · permalink

https://resinfo-gt.pages.in2p3.fr/zfs/doc/index.html

ZFS Fragmentation – my very little tricks

ZFS · fragmentation

February 24, 2026 at 3:53:20 PM GMT+1 * · permalink

https://fredpayet.fr/index.php/zfs-fragmentation/

ZFS I/O (ZIO) Scheduler — OpenZFS documentation

ZFS

February 24, 2026 at 3:52:57 PM GMT+1 * · permalink

https://openzfs.github.io/openzfs-docs/Performance%20and%20Tuning/ZIO%20Scheduler.html

Tuning the OpenZFS write throttle

ZFS

February 24, 2026 at 3:52:37 PM GMT+1 * · permalink

https://ahl.dtrace.org/2014/08/31/openzfs-tuning/

The strange case of the underestimated Merge Join node | Frédéric Yhuel, PostgreSQL DBA

get_actual_variable_range · PostgreSQL

February 6, 2026 at 2:57:50 PM GMT+1 * · permalink

https://yhuelf.github.io/2026/01/19/under-estimated-mergejoin.html

Waiting for Postgres 19: Better Planner Hints with Path Generation Strategies

PostgreSQL · pg19 · planner

February 5, 2026 at 10:29:02 PM GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-19-better-planner-hints

https://danolivo.substack.com/p/500-milliseconds-on-planning-how

PostgreSQL · planner

January 31, 2026 at 1:07:12 PM GMT+1 * · permalink

https://danolivo.substack.com/p/500-milliseconds-on-planning-how

GitHub - 3dg1luk43/ha_washdata: Home Assistant integration to detect washer cycles from smart plug power, match programs, and estimate time remaining

Home_Assistant

January 27, 2026 at 10:53:16 AM GMT+1 * · permalink

https://github.com/3dg1luk43/ha_washdata

Home Assistant & CO2

Home_Assistant

January 26, 2026 at 1:18:19 PM GMT+1 * · permalink

https://www.canaletto.fr/home-assistant-co2/

The strange case of the underestimated Merge Join node

PostgreSQL · get_actual_variable_range · planner · Internal

January 12, 2026 at 10:11:18 AM GMT+1 * · permalink

https://blog.dalibo.com/2026/01/12/under-estimated-mergejoin.html