Anayrat links

Selecting all Columns Except One in PostgreSQL – Java, SQL and jOOQ.

PostgreSQL · sql

May 14, 2018 at 7:02:02 PM GMT+2 * · permalink

https://blog.jooq.org/2018/05/14/selecting-all-columns-except-one-in-postgresql/

CAR: Clock with Adaptive Replacement

http://www.cse.iitd.ernet.in/~sbansal/pubs/fast04ppt.pdf

PostgreSQL · Algorithm

May 11, 2018 at 10:53:32 AM GMT+2 * · permalink

http://theory.stanford.edu/~sbansal/pubs/fast04.pdf

Unit testing functions in PostgreSQL with pgTAP in 5 simple steps

PostgreSQL · plpgsql · pgTAP

May 9, 2018 at 2:10:41 PM GMT+2 * · permalink

https://medium.com/engineering-on-the-incline/unit-testing-functions-in-postgresql-with-pgtap-in-5-simple-steps-beef933d02d3

The maze of the elephant

PostgreSQL · sql · constraint

May 9, 2018 at 2:04:06 PM GMT+2 * · permalink

http://www.pgdba.org/post/2018/05/dependency_maze/

PostgreSQL Data Types: Point

PostgreSQL · types · sql · GiST

May 7, 2018 at 2:25:06 PM GMT+2 * · permalink

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

avoid OR for better PostgreSQL query performance - Cybertec

PostgreSQL · sql

May 7, 2018 at 11:27:02 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/avoid-or-for-better-performance/

[ClusterLabs] Replicated PGSQL woes

PostgreSQL · HA

May 4, 2018 at 4:04:41 PM GMT+2 * · permalink

https://lists.clusterlabs.org/pipermail/users/2016-October/004342.html

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