Anayrat links

GitHub - laowantong/mocodo: Modélisation Conceptuelle de Données. Nickel. Ni souris.

SQL · modelisation

April 4, 2019 at 11:00:29 AM GMT+2 * · permalink

https://github.com/laowantong/mocodo

WTF is Big O Notation? – Rob Conery

Programming · Algorithm

March 26, 2019 at 6:21:00 PM GMT+1 * · permalink

https://rob.conery.io/2019/03/25/wtf-is-big-o-notation/

Indexes in PostgreSQL — 4 (Btree) / Postgres Professional corporate blog / Habr

PostgreSQL · index · Internal

March 26, 2019 at 3:59:14 PM GMT+1 * · permalink

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

PostgreSQL - Haute disponibilité avec Patroni

Patroni · PostgreSQL · HA

March 21, 2019 at 10:24:44 AM GMT+1 * · permalink

https://www.slideshare.net/slardiere/postgresql-haute-disponibilit-avec-patroni

Look It Up: Practical PostgreSQL Indexing

PostgreSQL · index · GiST · GIN · BRIN · Btree

March 20, 2019 at 3:54:27 PM GMT+1 * · permalink

https://thebuild.com/presentations/look-it-up-pgday-nordic-2019.pdf

Calculating Weighted Averages When Joining Tables in SQL – Java, SQL and jOOQ.

PostgreSQL · SQL · Window_function

March 15, 2019 at 11:21:34 AM GMT+1 * · permalink

https://blog.jooq.org/2019/03/15/calculating-weighted-averages-when-joining-tables-in-sql/

Recherche textuelle: un dictionnaire personnalisé pour affiner l'index

FTS · PostgreSQL

March 10, 2019 at 4:01:04 PM GMT+1 * · permalink

http://blog-postgresql.verite.pro/2019/03/10/dictionnaire-tsearch.html

NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: PostgreSQL at EXPLAIN EXTENDED

SQL · Postgis · Join · tuning · Tricks

March 5, 2019 at 5:58:37 PM GMT+1 * · permalink

https://explainextended.com/2009/09/16/not-in-vs-not-exists-vs-left-join-is-null-postgresql/

not in / not exist / left outer join where NULL

Remplacer NOT IN soit par NOT EXIST ou un left outer join where NULL

SQL · tuning · Tricks

March 5, 2019 at 5:57:41 PM GMT+1 * · permalink

/shaare/tJufpw

Debugging the Postgres query planner — GoCardless Blog

PostgreSQL · planner · Statistics

March 4, 2019 at 4:17:06 PM GMT+1 * · permalink

https://gocardless.com/blog/debugging-the-postgres-query-planner/

The art of writing eBPF programs: a primer. |Sysdig

eBPF · linux · perf

March 1, 2019 at 5:05:39 PM GMT+1 * · permalink

https://sysdig.com/blog/the-art-of-writing-ebpf-programs-a-primer/

pgBackRest - Performing Backups on a Standby Cluster

PostgreSQL · pgbackrest

February 28, 2019 at 4:58:36 PM GMT+1 * · permalink

https://info.crunchydata.com/blog/pgbackrest-performing-backups-on-a-standby-cluster

Postgres 12 highlight - WITH clause and materialization

PostgreSQL · CTE · pg12

February 28, 2019 at 11:14:15 AM GMT+1 * · permalink

https://paquier.xyz/postgresql-2/postgres-12-with-materialize/

Exclusive backup method is deprecated - what now? - Cybertec

PostgreSQL · Pitr · Backup

February 25, 2019 at 4:32:34 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/exclusive-backup-deprecated-what-now/

Postgres Job Queues & Failure By MVCC — Brandur Leach

PostgreSQL · MVCC · queues

February 25, 2019 at 12:40:38 PM GMT+1 * · permalink

https://brandur.org/postgres-queues

Integrated cache invalidation for better hit rates

PostgreSQL · pgQ

February 25, 2019 at 10:29:21 AM GMT+1 * · permalink

https://www.hagander.net/talks/cache_invalidation_2014.pdf

Parallel queries in PostgreSQL - Percona Database Performance Blog

PostgreSQL · Performance · Parallel

February 22, 2019 at 12:50:10 PM GMT+1 * · permalink

https://www.percona.com/blog/2019/02/21/parallel-queries-in-postgresql/

How Well a Query Optimizer Handles Subqueries? – Striving for Optimal Performance

PostgreSQL · planner

February 21, 2019 at 11:19:49 AM GMT+1 * · permalink

https://antognini.ch/2017/12/how-well-a-query-optimizer-handles-subqueries/

YOW2018 Cloud Performance Root Cause Analysis at Netflix

linux · benchmark · BPF · eBPF · perf

February 21, 2019 at 10:33:40 AM GMT+1 * · permalink

https://www.slideshare.net/brendangregg/yow2018-cloud-performance-root-cause-analysis-at-netflix

Pub-Sub avec Postgres

PostgreSQL · Python · queues

February 21, 2019 at 10:33:28 AM GMT+1 * · permalink

https://bersace.cae.li/postgres-agent-message-dramatiq.html