Anayrat links

Benchmark PostgreSQL With Linux HugePages - Percona Database Performance Blog

PostgreSQL · hugepages · linux

December 21, 2018 at 12:39:32 PM GMT+1 * · permalink

https://www.percona.com/blog/2018/12/20/benchmark-postgresql-with-linux-hugepages/

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

PostgreSQL · NULL · SQL

December 21, 2018 at 12:31:03 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/a-postgresql-story-about-null-is-null-null-and-not-null/

Migration PostgreSQL (presque) sans arrêt de production

PostgreSQL · Replication · logique

December 17, 2018 at 4:08:51 PM GMT+1 * · permalink

http://www.loxodata.com/post/migration_logique/

PostgreSQL major version upgrade using built in Logical Replication

PostgreSQL · logique · Replication · Upgrade

December 14, 2018 at 1:52:49 PM GMT+1 * · permalink

https://www.slideshare.net/AtsushiTorikoshi/postgresql-major-version-upgrade-using-built-in-logical-replication

Architecture & Pitfalls of Logical Replication

PostgreSQL · logique · Replication

December 14, 2018 at 1:52:27 PM GMT+1 * · permalink

https://www.slideshare.net/AtsushiTorikoshi/architecture-pitfalls-of-logical-replication

Containerizing Databases with Kubernetes and Stateful Sets - That Cluster Guy

Kubernetes · database

December 14, 2018 at 10:30:42 AM GMT+1 * · permalink

http://blog.clusterlabs.org/blog/2017/databases-on-kubernetes

What the SQL?! JOIN me at UNION Station

SQL · PostgreSQL · UNION

December 14, 2018 at 10:28:36 AM GMT+1 * · permalink

https://ddrscott.github.io/blog/2018/join-me-at-union-station/

What the SQL?!? Recursive

PostgreSQL · SQL · CTE · RECURSIVE

December 14, 2018 at 10:28:11 AM GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-recursive/

What the SQL?!? WINDOW

SQL · PostgreSQL · Window_function

December 14, 2018 at 10:27:01 AM GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-window/

What the SQL?!? Lateral Joins

PostgreSQL · Lateral · SQL

December 14, 2018 at 10:26:23 AM GMT+1 * · permalink

https://ddrscott.github.io/blog/2017/what-the-sql-lateral/

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

Greenplum · Kubernetes

December 14, 2018 at 10:25:43 AM GMT+1 * · permalink

http://engineering.pivotal.io/post/managing-stateful-apps/

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

Greenplum · Kubernetes

December 14, 2018 at 10:25:24 AM GMT+1 * · permalink

http://engineering.pivotal.io/post/storing-stateful-data/

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

Greenplum · Kubernetes

December 14, 2018 at 10:25:06 AM GMT+1 * · permalink

http://engineering.pivotal.io/post/provisioning-stateful-kube-containers/

Stateful Apps in Kubernetes · Pivotal Engineering Journal 1/4

Greenplum · Kubernetes

December 14, 2018 at 10:24:16 AM GMT+1 * · permalink

http://engineering.pivotal.io/post/stateful-apps-toc/

Bloat and Fragmentation in PostgreSQL

HoT · Vacuum · PostgreSQL

December 12, 2018 at 1:29:54 PM GMT+1 * · permalink

https://www.slideshare.net/masahikosawada98/bloat-and-fragmentation-in-postgresql

Demi jointures - semi join

SQL · Postgis · Join

December 12, 2018 at 9:34:17 AM GMT+1 * · permalink

http://pgphil.ovh/semi_join_11_01.php

Hooks in PostgreSQL

hook · PostgreSQL · Internal · hack

December 11, 2018 at 12:20:14 PM GMT+1 * · permalink

https://www.pgcon.org/2012/schedule/attachments/243_Hooks%20in%20PostgreSQL

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

hook · PostgreSQL · hack · Internal

December 11, 2018 at 12:19:54 PM GMT+1 * · permalink

https://github.com/AmatanHead/psql-hooks

prepared transactions and their dangers - Cybertec

2PC · prepare · PostgreSQL

December 11, 2018 at 11:45:29 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/prepared-transactions/

Kubernetes in Production: Services – okmeter.io blog

Kubernetes · PostgreSQL

December 10, 2018 at 2:31:22 PM GMT+1 * · permalink

https://blog.okmeter.io/kubernetes-in-production-services-34c3234c94c8