Anayrat links

Switchover/Switchback in PostgreSQL 9.3 | EnterpriseDB

PostgreSQL · HA

May 4, 2018 at 4:01:16 PM GMT+2 * · permalink

https://www.enterprisedb.com/node/3401

PostgreSQL: Sharing data across function calls - Cybertec

plpgsql · PostgreSQL

May 3, 2018 at 11:05:46 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-sharing-data-across-function-calls/

Atelier Initiation au langage Go

golang

May 3, 2018 at 9:48:25 AM GMT+2 * · permalink

https://github.com/leboncoin/atelier-initiation-golang

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

Programming · golang

May 3, 2018 at 9:38:52 AM GMT+2 * · permalink

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

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

entreprise · not_read

May 3, 2018 at 9:36:34 AM GMT+2 * · permalink

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

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

Decision · not_read

May 3, 2018 at 9:29:44 AM GMT+2 * · permalink

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

SERIALIZABLE in PostgreSQL 11... and beyond

PostgreSQL · Isolation · SERIALIZABLE · lock · skip

May 3, 2018 at 9:11:46 AM GMT+2 * · permalink

https://write-skew.blogspot.fr/2018/05/serializable-in-postgresql-11-and-beyond.html

PostgreSQL Data Types: ENUM

PostgreSQL · types · enum

May 2, 2018 at 1:23:44 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/05/postgresql-data-types-enum/

select * from depesz; » Blog Archive » Waiting for PostgreSQL 11 – Support partition pruning at execution time

PostgreSQL · partionning

May 1, 2018 at 7:58:39 PM GMT+2 * · permalink

https://www.depesz.com/2018/05/01/waiting-for-postgresql-11-support-partition-pruning-at-execution-time/

The Logical Disaster of Null – Rob Conery

Programming

May 1, 2018 at 7:57:11 PM GMT+2 * · permalink

https://rob.conery.io/2018/05/01/the-logical-disaster-of-null/

Issues related to PL/pgSQL usage

PostgreSQL · plpgsql · Performance

May 1, 2018 at 4:54:48 PM GMT+2 * · permalink

https://postgres.cz/files/plpgsql_issues.pdf

QueryRecorder | GitLab

QueryRecorder is a tool for detecting the N+1 queries problem from tests.

gitlab · n+1 · ruby

April 30, 2018 at 7:48:08 PM GMT+2 * · permalink

https://docs.gitlab.com/ee/development/query_recorder.html

Severe site degradation due to database load - Google Docs

PostgreSQL · outage · gitlab

April 30, 2018 at 7:18:59 PM GMT+2 * · permalink

https://docs.google.com/document/d/1_IzyO-jwqb7UFl0A28D1gR4EaU99cEnoUSD9o8q4eZw/edit

mermaid · GitBook

April 30, 2018 at 4:42:19 PM GMT+2 * · permalink

https://mermaidjs.github.io/

Tech preview: PostgreSQL 11 - CREATE PROCEDURE - Cybertec

PostgreSQL · sql · plpgsql · procedure

April 30, 2018 at 4:42:01 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/tech-preview-postgresql-11-create-procedure/

PostgreSQL Data Types: JSON

PostgreSQL · JSON · types

April 30, 2018 at 4:41:45 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-json/

Oracle. Tuning the Buffer Cache

Oracle · Internal

April 30, 2018 at 4:12:15 PM GMT+2 * · permalink

http://slideplayer.com/slide/4002724/

Why Auto Increment Is A Terrible Idea - Clever Cloud Blog

uuid · PostgreSQL

April 30, 2018 at 4:10:08 PM GMT+2 * · permalink

https://www.clever-cloud.com/blog/engineering/2015/05/20/why-auto-increment-is-a-terrible-idea/

Benchmarking UUIDs, v2

PostgreSQL · uuid

April 30, 2018 at 4:04:35 PM GMT+2 * · permalink

https://jasonaowen.net/blog/2017/Apr/13/benchmarking-uuids-v2/

How to get a core dump for a segfault on Linux - Julia Evans

GDB · valgrind · hack

April 29, 2018 at 5:57:06 PM GMT+2 * · permalink

https://jvns.ca/blog/2018/04/28/debugging-a-segfault-on-linux/