Search: [PostgreSQL] - Anayrat links

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

PostgreSQL · pgcrypto · Encryption · Security

August 4, 2023 at 1:04:55 PM GMT+2 * · permalink

https://blog.capdata.fr/index.php/chiffrement-des-donnees-sous-postgresql/

Reproducible builds: a PostgreSQL query optimization example

Replace NOT IN by NOT EXISTS

PostgreSQL · Tricks · NOT_IN · exists · IN

July 26, 2023 at 12:55:52 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/reproducible-builds-postgresql-query-optimization/

Subqueries and performance in PostgreSQL - CYBERTEC

PostgreSQL · SQL · exists · optimizer

July 11, 2023 at 11:47:17 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/subqueries-and-performance-in-postgresql/

TIL - IN is not the same as ANY

PostgreSQL · IN · SQL

July 5, 2023 at 11:51:19 AM GMT+2 * · permalink

https://kmoppel.github.io/2023-07-04-til-in-is-not-the-same-as-any/

Memory context: how PostgreSQL allocates memory - CYBERTEC

PostgreSQL · Internal · memory

June 29, 2023 at 1:34:20 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/memory-context-for-postgresql-memory-management/

Unexpected downsides of UUID keys in PostgreSQL - CYBERTEC

PostgreSQL · uuid

June 26, 2023 at 1:24:43 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/unexpected-downsides-of-uuid-keys-in-postgresql/

Postgres Partition Pains - LockManager Waits

https://postgrespro.ru/list/thread-id/2500195
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/wait-event.lw-lock-manager.html

PostgreSQL · LWLocks · lock

June 23, 2023 at 4:37:56 PM GMT+2 * · permalink

https://www.kylehailey.com/post/postgres-partition-pains-lockmanager-waits

Classification des caractères avec ICU

PostgreSQL · ICU

June 11, 2023 at 9:08:06 PM GMT+2 * · permalink

http://blog-postgresql.verite.pro/2023/06/11/caracteres-icu.html

Comment créer une extension pour PostgreSQL

PostgreSQL · hack · Extension

June 8, 2023 at 11:28:41 PM GMT+2 * · permalink

https://blog.dalibo.com/2023/06/08/hackingpg1.html

High-compression Metrics Storage with Postgres Hyperloglog

PostgreSQL · Extension · Hyperloglog

June 8, 2023 at 10:19:52 AM GMT+2 * · permalink

https://www.crunchydata.com/blog/high-compression-metrics-stograge-with-postgres-hyperloglog

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

PostgreSQL · GiST · Internal · pgcon2023

June 5, 2023 at 3:38:50 PM GMT+2 * · permalink

https://github.com/x4m/gist2023

A tale about (incomplete) upgrade from PostgreSQL 12 to 14 – select * from depesz;

PostgreSQL · Replication · logique

June 4, 2023 at 7:48:21 PM GMT+2 * · permalink

https://www.depesz.com/2023/06/04/a-tale-about-incomplete-upgrade-from-postgresql-12-to-14/

PostgreSQL 16 New Features With Examples (Beta 1)

PostgreSQL · pg16

June 2, 2023 at 11:02:14 AM GMT+2 * · permalink

https://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL16Beta1_New_Features_en_20230528_1.pdf

Automating Index Selection Using Constraint Programming

PostgreSQL · Conference · hypopg · pg_qual_stats

June 2, 2023 at 10:56:56 AM GMT+2 * · permalink

https://resources.pganalyze.com/pganalyze_Automating_Index_Selection_using_Constraint_Programming.pdf

Robert Haas: Do I Really Need That backup_label File?

PostgreSQL · Backup · Pitr

June 2, 2023 at 10:52:16 AM GMT+2 * · permalink

http://rhaas.blogspot.com/2023/05/do-i-really-need-that-backuplabel-file.html

Logical Replication on Standbys in Postgres 16

PostgreSQL · pg16 · logique · Replication

June 2, 2023 at 10:44:01 AM GMT+2 * · permalink

https://www.crunchydata.com/blog/logical-replication-on-standbys-in-postgres-16

ALTER DEFAULT PRIVILEGES in PostgreSQL - CYBERTEC

PostgreSQL · Privileges

May 17, 2023 at 12:07:10 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-alter-default-privileges-permissions-explained/

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

PostgreSQL · uuid · ulid

May 5, 2023 at 1:39:18 PM GMT+2 * · permalink

https://www.youtube.com/watch?v=iZtssl7rkBU

Join order: how to force it in PostgreSQL - CYBERTEC

PostgreSQL · Join · planner

May 4, 2023 at 1:38:01 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/forcing-a-join-order-in-postgresql/

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

PostgreSQL · Internal · LWLocks

May 4, 2023 at 12:11:36 PM GMT+2 * · permalink

https://gitlab.com/gitlab-com/gl-infra/scalability/-/issues/2301