Anayrat links

Beyond EXPLAIN - Query Optimization From Theory To Code

PostgreSQL · Statistics

November 23, 2018 at 11:21:59 AM GMT+1 * · permalink

https://www.pgcon.org/2016/schedule/attachments/433_PGCON2016_beyond_explain.pdf

How to Aggregate an Archive Log’s Deltas into a Snapshot with SQL – Java, SQL and jOOQ.

PostgreSQL · SQL

November 20, 2018 at 10:17:59 AM GMT+1 * · permalink

https://blog.jooq.org/2018/11/16/how-to-aggregate-an-archive-logs-deltas-into-a-snapshot-with-sql/

AUTO PLAN TUNING USING FEEDBACK LOOP

PostgreSQL · planner · Statistics · pg_plan_advsr

November 19, 2018 at 4:12:50 PM GMT+1 * · permalink

https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2132/slides/143/PGConfEU2018_auto_plan_tuning_by_Tatsuro_Yamada.pdf

PostgresSQL: Implicit vs. explicit joins - Cybertec

PostgreSQL · Join

November 19, 2018 at 2:18:28 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/postgressql-implicit-vs-explicit-joins/

Postgres 11 partitioning | Denish Patel

PostgreSQL · partionning · pg11

November 16, 2018 at 6:02:08 PM GMT+1 * · permalink

http://www.pateldenish.com/2018/11/postgres-11-partitioning.html

PGDay UK 2016 -- Performace for queries with grouping

PostgreSQL · tuning · SQL · Hash · loose_index_scan

November 14, 2018 at 2:19:48 PM GMT+1 * · permalink

https://www.slideshare.net/AlexeyBashtanov/pgday-uk-2016-performace-for-queries-with-grouping

On the benefits of sorted paths |

PostgreSQL · SQL · tuning · Hash

November 14, 2018 at 2:07:40 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/on-the-benefits-of-sorted-paths/

Simulateur Concurrence

MVCC · Isolation · formation

November 13, 2018 at 2:21:28 PM GMT+1 * · permalink

https://mooc-bador.inria.fr/transactions/

Big-O Algorithm Complexity Cheat Sheet (Know Thy Complexities!) @ericdrowell

complexity · bigO · Programming · Algorithm

November 13, 2018 at 2:02:19 PM GMT+1 * · permalink

http://bigocheatsheet.com

PostgreSQL Alter Table and Long Transactions | Joshua Kehn

PostgreSQL · DDL · schema_migration

November 13, 2018 at 1:58:40 PM GMT+1 * · permalink

http://www.joshuakehn.com/2017/9/9/postgresql-alter-table-and-long-transactions.html

Safe and unsafe operations for high volume PostgreSQL

PostgreSQL · DDL · schema_migration

November 13, 2018 at 1:57:55 PM GMT+1 * · permalink

https://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql#.W-rKAJuZ3mE

Safe Operations For High Volume PostgreSQL

PostgreSQL · schema · schema_migration · DDL

November 13, 2018 at 1:56:38 PM GMT+1 * · permalink

https://www.braintreepayments.com/blog/safe-operations-for-high-volume-postgresql/

I/O scheduling for single-queue devices [LWN.net]

linux · Internal · scheduler · storage

November 13, 2018 at 1:44:36 PM GMT+1 * · permalink

https://lwn.net/Articles/767987/

Column And Table Redefinition With Minimal Locking | Ardent Performance Computing

PostgreSQL · lock · schema_migration · DDL

November 13, 2018 at 12:28:35 PM GMT+1 * · permalink

https://ardentperf.com/2018/11/08/column-and-table-redefinition-with-minimal-locking/

enix.io - Il est lent ton réseau, GRO

linux · System · Network

November 11, 2018 at 5:32:43 PM GMT+1 * · permalink

https://enix.io/fr/blog/il-est-lent-ton-reseau-gro/

An index only scan in PostgreSQL is not always index only - Blog dbi services

PostgreSQL · index

November 11, 2018 at 5:28:36 PM GMT+1 * · permalink

https://blog.dbi-services.com/an-index-only-scan-in-postgresql-is-not-always-index-only/

Tracking foreign keys throughout a schema - Magnus Hagander's blog

PostgreSQL · fk · Tricks

November 8, 2018 at 10:23:44 AM GMT+1 * · permalink

https://blog.hagander.net/tracking-foreign-keys-throughout-a-schema-242/

Foreign Key to partitioned table – part 2 – select * from depesz;

PostgreSQL · fk · partionning

November 8, 2018 at 9:30:04 AM GMT+1 * · permalink

https://www.depesz.com/2018/10/31/foreign-key-to-partitioned-table-part-2/

Foreign Key to partitioned table – part 3 – select * from depesz;

PostgreSQL · fk · partionning

November 8, 2018 at 9:29:05 AM GMT+1 * · permalink

https://www.depesz.com/2018/11/04/foreign-key-to-partitioned-table-part-3/

PGCon 2018 - vidéos

PostgreSQL · Conference · pgcon2018

November 8, 2018 at 9:25:20 AM GMT+1 * · permalink

https://www.youtube.com/playlist?list=PLuJmmKtsV1dOGaKJuHOH0GIfvFOBghu7O