Anayrat links

Walking with the Elephants: Advanced partition matching for partition-wise join

PostgreSQL · partionning · wisejoin

January 26, 2022 at 9:06:45 AM GMT+1 * · permalink

http://ashutoshpg.blogspot.com/2020/07/advanced-partition-matching-for.html

Practical Examples of Data Normalization in PostgreSQL - CYBERTEC

normalisation · SQL

January 25, 2022 at 9:44:23 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/practical-examples-data-normalization-in-postgresql/

Migrating a PostgreSQL cluster managed by Patroni – Flant blog

PostgreSQL · HA · Patroni · not_read

January 14, 2022 at 1:23:47 PM GMT+1 * · permalink

https://blog.flant.com/migrating-a-postgresql-cluster-managed-by-patroni/

Effective Error Handling in Golang - Earthly Blog

golang · errors

January 14, 2022 at 11:29:54 AM GMT+1 * · permalink

https://earthly.dev/blog/golang-errors/

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

PostgreSQL · monitoring

January 14, 2022 at 10:59:02 AM GMT+1 * · permalink

https://postgres.ai/blog/20220114-progress-bar-for-postgres-queries-lets-dive-deeper

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

PostgreSQL · Replication · logique · Patroni

January 13, 2022 at 5:33:17 PM GMT+1 * · permalink

https://www.percona.com/blog/how-patroni-addresses-the-problem-of-the-logical-replication-slot-failover-in-a-postgresql-cluster/

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

freelance

January 12, 2022 at 10:09:33 PM GMT+1 * · permalink

https://eventuallycoding.com/2022/01/11/outil-de-calcul-de-revenus-pour-freelance-et-salaries/

Rails: Postgres Native Partitioning

PostgreSQL · ruby · partionning

January 7, 2022 at 9:36:10 PM GMT+1 * · permalink

https://www.johnnunemaker.com/rails-postgres-native-partitioning/

Limiter les ressources d'une ligne de commande avec systemd | Linux Embedded

linux · systemd · cgroup

January 1, 2022 at 2:53:56 PM GMT+1 * · permalink

http://www.linuxembedded.fr/2021/11/limiter-les-ressources-dune-ligne-de-commande-avec-systemd

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

linux · Programming · Parallel · not_read · Algorithm

December 26, 2021 at 11:39:39 AM GMT+1 * · permalink

https://paulmck.livejournal.com/66892.html

Everything I've seen on optimizing Postgres on ZFS

ZFS · PostgreSQL

December 22, 2021 at 9:32:10 PM GMT+1 * · permalink

https://vadosware.io/post/everything-ive-seen-on-optimizing-postgres-on-zfs-on-linux/

Time-series compression algorithms, explained

TimescaleDB · TimeSeries · SQL · PostgreSQL · compression · Gorilla · Simple-8b · Delta_encoding

December 21, 2021 at 11:06:25 AM GMT+1 * · permalink

https://blog.timescale.com/blog/time-series-compression-algorithms-explained/

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

Postgis · formation · not_read

December 16, 2021 at 10:52:38 PM GMT+1 * · permalink

https://github.com/3liz/formation-postgis

Locks in PostgreSQL: 4. Locks in memory / Habr

PostgreSQL · Internal · lock · wait_event · spinlock

December 15, 2021 at 7:19:35 PM GMT+1 * · permalink

https://habr.com/en/company/postgrespro/blog/507036/

Manage encryption keys with PostgreSQL TDE - CYBERTEC

PostgreSQL · tde · Security · Encryption

December 15, 2021 at 1:11:35 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/manage-encryption-keys-with-postgresql-tde/

orioledb-postgresbuild-2021

https://vimeo.com/649616139

PostgreSQL · MVCC · OrioleDB · Internal

December 15, 2021 at 9:16:40 AM GMT+1 * · permalink

https://raw.githubusercontent.com/orioledb/orioledb/main/orioledb-postgresbuild-2021.pdf

Postgres HA: roles are dynamic

not_read · PostgreSQL

December 15, 2021 at 8:46:37 AM GMT+1 * · permalink

https://tapoueh.org/blog/2021/12/postgres-ha-roles-are-dynamic/

zheap UNDO logs discarding in PostgreSQL - CYBERTEC

PostgreSQL · zheap · MVCC

December 14, 2021 at 11:51:11 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/zheap-undo-logs-discarding-in-postgresql/

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

PostgreSQL · Permissions · Privileges · Security

December 14, 2021 at 9:06:41 AM GMT+1 * · permalink

https://www.tangramvision.com/blog/hands-on-with-postgresql-authorization-part-1-roles-and-grants

Explore the new SEARCH and CYCLE features in PostgreSQL 14

PostgreSQL · CTE · RECURSIVE

December 14, 2021 at 9:06:20 AM GMT+1 * · permalink

https://aiven.io/blog/explore-the-new-search-and-cycle-features-in-postgresql-14